Hi
Try this:
=IF(AND(AR5=0,AT5=0),(10/1*AW5)+(10/3*1),IF(AR5=0,(10/3*AW5)+(10/3*1),(10/5*AW5)+(10/5*1)))
Andy.
"rsbergeron" wrote
in message ...
I am trying to get this if statement to work, but I keep getting an
error when I exit the cell. Please Help!
=(IF(AR5=0 & AT5=0,(10/1*AW5)+(10/3*1),(if
AR5=0,(10/3*AW5)+(10/3*1),(10/5*AW5)+(10/5*1))))
--
rsbergeron
------------------------------------------------------------------------
rsbergeron's Profile:
http://www.excelforum.com/member.php...o&userid=24817
View this thread: http://www.excelforum.com/showthread...hreadid=383708