Need FORMULA help please! Converting # from countif function and converting it into individual cells

[ap718]

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!!

@Olaf Hubel

@Sergei Baklan 

@Haytham Amairah 

@Detlef Lewin 

@Wyn Hopkins 

[#2]

@ap718

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