Thread: =IF ..OR.. =IF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brian Withun Brian Withun is offline
external usenet poster
  
Posts: 9
Default =IF ..OR.. =IF
=IF(A1="G",g,IF(A1="J",j,"ERROR"))


this presupposes that g and j are defined to be something, otherwise
you'll just get a #NAME? error

Brian Herbert Withun

Reply With QuoteReply With Quote