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

=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?

=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

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?