Nested If statement
 

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

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