Thread: Formula True False help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Formula True False help
Easy

wrap your formule iwth this

if((old_formula) = 1, "True","False")


"Lisa" wrote:

In a formula, I need the cell to display the word "YES" instead of true, and
stay blank if false.
Reply With QuoteReply With Quote