View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Formula True False help

Without seeing your formula, it is hard to give a specific answer, but
try
=if(current formula,"Yes","")
it may have to be modified some depending on your current formula
"Lisa" wrote:

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