Jun 13 2019 07:10 AM - edited Jun 13 2019 07:17 AM
Hi - I need help choosing the best formula. Using #'s 1-10, I need to convert this into individual fields in excel.
For example, if I have the number "4" in ONE cell, I need this to translate into FOUR cells:
Cell 1 - $400
Cell 2 - $400
Cell 3 - $400
Cell 4 - $400
Thank you!!
Jun 13 2019 08:31 AM
Hi,
Sorry, but your request isn't clear enough!
Could you clarify it?
However, try this solution below, it might be close to what you asking for.
=IF(ROW(A1)<=$A$1,TEXT($A$1&"00","$#"),"")
Regards