Hello,
I am trying to get this IF statement to work but it wont validate.
=IF(W32>0.01,ROUND(((P32*W32*R32/100)+SUM(X32:AA32)*R32*P32/100),0),IF(U32>0.01,ROUND(((P32*U32*R32/100)+SUM(X32:AA32)*R32*P32/100),0),IF(T32>0.01,ROUND(((P32*T32/100)+SUM(X32:Z32))*R32/100,0)))+(Q32*AA32*R32/100)+(Q32*AB32*R32/100)+(Q32*AC32*R32/100)+(Q32*AD32*R32/100)+(Q32*V32*R32/100))
I am trying to get these IF statements to not double up but it looks like it is when I put an amount on cell P. I just want it to calculate the amount one time based off if there is a value in W or U or T. It seems to be doubling up and I dont know why am I doubling up somewhere? The circled amount below should be based off the actual amount which is lower then estimated so the premium balance should be less.
I am trying to get this IF statement to work but it wont validate.
=IF(W32>0.01,ROUND(((P32*W32*R32/100)+SUM(X32:AA32)*R32*P32/100),0),IF(U32>0.01,ROUND(((P32*U32*R32/100)+SUM(X32:AA32)*R32*P32/100),0),IF(T32>0.01,ROUND(((P32*T32/100)+SUM(X32:Z32))*R32/100,0)))+(Q32*AA32*R32/100)+(Q32*AB32*R32/100)+(Q32*AC32*R32/100)+(Q32*AD32*R32/100)+(Q32*V32*R32/100))
I am trying to get these IF statements to not double up but it looks like it is when I put an amount on cell P. I just want it to calculate the amount one time based off if there is a value in W or U or T. It seems to be doubling up and I dont know why am I doubling up somewhere? The circled amount below should be based off the actual amount which is lower then estimated so the premium balance should be less.