Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-690296%22%20slang%3D%22en-US%22%3ENeed%20FORMULA%20help%20please!%20Converting%20%23%20from%20countif%20function%20and%20converting%20it%20into%20individual%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690296%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20need%20help%20choosing%20the%20best%20formula.%20Using%20%23's%201-10%2C%20I%20need%20to%20convert%20this%20into%20individual%20fields%20in%20excel.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EFor%20example%2C%20if%20I%20have%20the%20number%20%224%22%20in%20ONE%20cell%2C%20I%20need%20this%20to%20translate%20into%20FOUR%20cells%3A%3C%2FP%3E%3CP%3ECell%201%20-%20%24400%3C%2FP%3E%3CP%3ECell%202%20-%20%24400%3C%2FP%3E%3CP%3ECell%203%20-%20%24400%3C%2FP%3E%3CP%3ECell%204%20-%20%24400%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89%22%20target%3D%22_blank%22%3E%40Olaf%20Hubel%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-690296%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690538%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20FORMULA%20help%20please!%20Converting%20%23%20from%20countif%20function%20and%20converting%20it%20into%20individual%20c%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690538%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359718%22%20target%3D%22_blank%22%3E%40ap718%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20but%20your%20request%20isn't%20clear%20enough!%3C%2FP%3E%3CP%3ECould%20you%20clarify%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20try%20this%20solution%20below%2C%20it%20might%20be%20close%20to%20what%20you%20asking%20for.%3C%2FP%3E%3CPRE%3E%3DIF(ROW(A1)%26lt%3B%3D%24A%241%2CTEXT(%24A%241%26amp%3B%2200%22%2C%22%24%23%22)%2C%22%22)%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20988px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F118041i999324ADAFF15693%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-06-13_18-29-52.png%22%20title%3D%222019-06-13_18-29-52.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
ap718
Occasional Visitor

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 

1 Reply

@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","$#"),"")

2019-06-13_18-29-52.png

 

 

Regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies