Nested If statement

R

rsbergeron

I am trying to get this if statement to work, but I keep getting a
error when I exit the cell. Please Help!

=(IF(AR5=0 & AT5=0,(10/1*AW5)+(10/3*1),(i
AR5=0,(10/3*AW5)+(10/3*1),(10/5*AW5)+(10/5*1)))
 
G

Guest

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.
 
Top