Format Number within formula

=IF(Pivots!E233>0, "Up "&Pivots!E233,"Down "&Pivots!E233)

Here is formula returning the result Up 2109.454654

I need the formula to return Up $2,109

Thanks

Microsoft Excel

Last Comment

Seamus2626

8/22/2022 - Mon

Subodh Tiwari (Neeraj)

3/31/2016

Try this....

=IF(Pivots!E233>0, "Up "&DOLLAR(Pivots!E233,0),"Down "&DOLLAR(Pivots!E233,0))

Open in new window

Professor J

3/31/2016

Wrap the formula inside text function

=TEXT(your formula , the format )

Here is the solution try this =TEXT(IF(Pivots!E233>0, "Up "&Pivots!E233,"Down "&Pivots!E233),"$#,##0")

Seamus2626

3/31/2016

ASKER

=IF(Pivots!E233>0, "Up "&DOLLAR(Pivots!E233,0),"Down "&DOLLAR(Pivots!E233,0))

Weirdly that is returning the pound sign!!

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

ASKER CERTIFIED SOLUTION

Professor J

3/31/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.