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!
 
redb,
Seems appropriate to me.

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

NickHK
 
Thanks! I knew there was a simple solution, but I just couldn't get the
formula to work out. This helps a lot!
 
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 1
Rolling Total 6
Extracting a Part of a Formula as Text 5
Add to a "number as text" 10
Macro 1
Dynamic Sum Array Formula Input Help 3
Matching Data between 2 Tabs on Same Workbook - then calculating 2
Help with Formula - Concatenate 4

Back
Top