Thread: Multiple ifs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MattShoreson
 
Posts: n/a
Default Multiple ifs

=IF(OR(ISBLANK(B22),B22=0),0,IF(C22="x",B22*80*1.5 ,IF(C22<"x",MAX((B22*80),18.75))))


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=530502

Reply With QuoteReply With Quote