formula with text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi

Try
=IF(A1=A2,"Nothing Owed","$"&text((A1-A2),"0.00"&" needs to be paid.")

Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula with text string 4
Dynamic Sum Array Formula Input Help 3
A formula that autofills by trend rather than linear 1
cell display 2 4
how look up this way? 2
Formating numbers &"Text" to appear as currency &"Text" in formula 6
Fill Options & Formula Help 2
Please help with a date formula. 3

Back
Top