View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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?