View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James W James W is offline
external usenet poster
 
Posts: 1
Default Returning a value if false

I have a spreadsheet that I am working on. It has a row that has either an X
or an O for about 30 days. I am trying to write a formula that will review
that row and give me a result of either Yes if there are all O's or No if
there are ANY X'S. I know this is something extremely simple to do but I cant
get it to work for the life of me.