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!

formula with text string
 

Sorry - I put this question in the wrong forum!

formula with text string
 

see reply posted to question in excel.misc
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!

formula with text string
 

redb,
Seems appropriate to me.

=IF(A1=A2,"Nothing Owed",DOLLAR(A1-A2) & " needs to be paid.")

NickHK

"redb" wrote in message
...
Sorry - I put this question in the wrong forum!

formula with text string
 

Thanks! I knew there was a simple solution, but I just couldn't get the
formula to work out. This helps a lot!

"NickHK" wrote:

redb,
Seems appropriate to me.

=IF(A1=A2,"Nothing Owed",DOLLAR(A1-A2) & " needs to be paid.")

NickHK

"redb" wrote in message
...
Sorry - I put this question in the wrong forum!