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?