| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula with text string
Okay, my problem is as follows:
A1=10 A2=5 In D1, the formula is: =IF(A1=A2,"Nothing Owed",(A1-A2)&" needs to be paid.") At the moment, D1 says "5 needs to be paid.", but I want it to say "$5.00 needs to be paid." How do I change the formula? (All cells are designed to show as currency.) Thanks so much, I just can't seem to make it work! |
|
#2
|
|||
|
|||
|
Hi
Try =IF(A1=A2,"Nothing Owed","$"&text((A1-A2),"0.00"&" needs to be paid.") Regards Roger Govier redb wrote: Okay, my problem is as follows: A1=10 A2=5 In D1, the formula is: =IF(A1=A2,"Nothing Owed",(A1-A2)&" needs to be paid.") At the moment, D1 says "5 needs to be paid.", but I want it to say "$5.00 needs to be paid." How do I change the formula? (All cells are designed to show as currency.) Thanks so much, I just can't seem to make it work! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Being treated as Text | Excel Worksheet Functions | |||
| specify range name in formula with concatenated string | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Coverting Formula to Text | Excel Discussion (Misc queries) | |||
| How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
Linear Mode
