How would I display the word "Paid" if the value of another cell=
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 of another cell=
=IF(A10,"Paid","")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Dundee" wrote in message ... 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 of another cell=
=if(a10,"Paid","Not Paid")
would be one way. Dundee wrote: How would I display the word "Paid" if the value in another cell in the worksheet had a value greater than 0? -- Dave Peterson |
How would I display the word "Paid" if the value of another cell=
One way:
Assume you want "Paid" to show up in cell B1 if cell A1 0. Then enter this in cell B1: =IF(A10,"Paid","") In article , Dundee wrote: How would I display the word "Paid" if the value in another cell in the worksheet had a value greater than 0? |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com