CODEWITHSUNDEEP
excelexcel-formula
Samantha
Samantha

Reputation: 75

How to convert Excel's IF function number result to currency?

I have the following if function: =IF(B6>=0, "100","0") and I would like to convert the result(s) to currency ($) and work with them.

I have tried the following: =IF(B6>=0, "$100","$0") and it gave back the dollar sign, however, it was not an actual currency cell after all and I could not work with it.

The result should be: either $100 or $0 but should be in currency.

Upvotes: 0

Views: 3077

Answers (2)

REXXman
REXXman

Reputation: 386

Using the Text function is another way to format information in cells.

=IF(B6>=0,TEXT( 100,"_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)"))

Upvotes: 0

JvdV
JvdV

Reputation: 75890

You just need to format the cell to currency, you can also drop the quotations

=IF(B6>=0,100,0)

enter image description here

Upvotes: 2

Related Questions