G Guest Nov 20, 2005 #1 How would I display the word "Paid" if the value in another cell in the worksheet had a value greater than 0?
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 Nov 20, 2005 #2 =IF(A1>0,"Paid","") -- HTH Bob Phillips (remove nothere from email address if mailing direct)
D Dave Peterson Nov 20, 2005 #3 =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...
=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 Nov 20, 2005 #4 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","")
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","")
