Thread: Need Conditional Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MatthewFlinchem
 
Posts: n/a
Default Need Conditional Formula

=IF(E2=1,D2/70),IF(E2=2,D2/200),IF(E2=3,D2/250),0

I am trying to use the formula above and have a few more "if's" to add
but this is not working. I have tried multiple things including "AND".
Any assistance would really make my day!

Thanks,

Matt


--
MatthewFlinchem
------------------------------------------------------------------------
MatthewFlinchem's Profile: http://www.excelforum.com/member.php...o&userid=34112
View this thread: http://www.excelforum.com/showthread...hreadid=538845

Reply With QuoteReply With Quote