Forum Discussion
Need FORMULA help please! Converting # from countif function and converting it into individual cells
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!!
1 Reply
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
