Thread: multiple IF statements
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default multiple IF statements
On Jul 27, 11:06 am, Duke Carey
wrote:
Rick & Joe -

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!

Reply With QuoteReply With Quote