Converting cell ref. w/num to currency
 

I am trying to figure out how to handle a value (i.e. 4.50) that is referenced in a cell to show as currency.

Here is the formula that I currently have and wonder if anyone knows how to convert to currency. Currently it converts $4.50 to 4.5

=IF(J43<0,"X currently owes $" & J44, "Y currently owes $" & J44)

Cell J44 contains the amount that is being referenced. In this example, it contains 4.5 ... but I want it to show in the cell that has the formula as $x.xx

Any help is appreciated!

Lenny

Hi Lenny

Try
=IF(J43<0,"X currently owes $" & text(J44,"0.00"), "Y currently owes $" &
text(J44,"0.00"))
Regards

Roger Govier


lulanosk wrote:
I am trying to figure out how to handle a value (i.e. 4.50) that is
referenced in a cell to show as currency.

Here is the formula that I currently have and wonder if anyone knows
how to convert to currency. Currently it converts $4.50 to 4.5

=IF(J43<0,"X currently owes $" & J44, "Y currently owes $" & J44)

Cell J44 contains the amount that is being referenced. In this
example, it contains 4.5 ... but I want it to show in the cell that has
the formula as $x.xx

Any help is appreciated!

Lenny