Formulas cell a="Not Paid" if cell B-C=$0
B Bob Phillips Mar 6, 2008 #3 =IF(B2-C2=0,"Not Paid","Paid") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=IF(B2-C2=0,"Not Paid","Paid") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
D Dave Peterson Mar 6, 2008 #4 One more: =IF(B2=C2,"Not Paid","Paid") Formulas cell a="Not Paid" if cell B-C=$0 Click to expand...