Thread: If statement conversion from Lotus to Excel2007
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C-town C-town is offline
external usenet poster
  
Posts: 1
Default If statement conversion from Lotus to Excel2007
I have never included 'OR' in an if statement.
How will the following statements need to be written excel to get it them
work?

@IF($A$5-I10<30#OR#I10="ACTIVE",D10-AG10,D10-E10)

@IF(I10=0#OR#I10=$A$5," NO"," YES")
Reply With QuoteReply With Quote