Thread: =IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chad chad is offline
external usenet poster
  
Posts: 273
Default =IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5
I enter this formula and I get a #value error.
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S59),"XX", "
").

How do I get "XX" instead of having a number value.
Reply With QuoteReply With Quote