ExcelBanter - formula with text string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula with text string (https://www.excelbanter.com/excel-discussion-misc-queries/47721-formula-text-string.html)

redb

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!

Roger Govier

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!

All times are GMT +1. The time now is 11:36 PM.