ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excellFormulas (https://www.excelbanter.com/excel-discussion-misc-queries/178990-excellformulas.html)

Chris

excellFormulas
 
Formulas
cell a="Not Paid" if cell B-C=$0

Teethless mama

excellFormulas
 
In A2: =IF(B2-C2=0,"Not Paid","")


"Chris" wrote:

Formulas
cell a="Not Paid" if cell B-C=$0


Bob Phillips

excellFormulas
 
=IF(B2-C2=0,"Not Paid","Paid")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Chris" wrote in message
...
Formulas
cell a="Not Paid" if cell B-C=$0




Dave Peterson

excellFormulas
 
One mo
=IF(B2=C2,"Not Paid","Paid")

Chris wrote:

Formulas
cell a="Not Paid" if cell B-C=$0


--

Dave Peterson


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com