How would I display the word "Paid" if the value of another cell=

D

Dundee

How would I display the word "Paid" if the value in another cell in the
worksheet had a value greater than 0?
 
B

Bob Phillips

=IF(A1>0,"Paid","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

=if(a1>0,"Paid","Not Paid")

would be one way.


How would I display the word "Paid" if the value in another cell in the
worksheet had a value greater than 0?
Click to expand...
 
J

JE McGimpsey

One way:

Assume you want "Paid" to show up in cell B1 if cell A1 > 0. Then enter
this in cell B1:

=IF(A1>0,"Paid","")
 
Top