Thread: multiple IF statements
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default multiple IF statements
The OP's specs omit 21 and 35 as conditions where he
wants a zero result, so your solutions incorporating MOD()
will be erroneous

Good eye!

Yes indeed... I completely missed that!

Rick
Reply With QuoteReply With Quote