| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Converting cell contents to a formula | Excel Worksheet Functions | |||
| Converting string of info in one cell into multiple | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
