IF THEN statement problem

[jm2241]

Hi. I'm using the following if/then statement in cell A1 cell to refer to two other cell values (the cells are named "rof" and "fee"). When I change the numerical data in cell "rof" or "fee" the A1 cell does not adjust accordingly. Any help here is appreciated. Here is the formula:

=IF(fee=1,((AOO38)*(1-rof)/fee),IF(fee=2,(SUM(AOO38,AOA38)*(1-rof)/fee),IF(fee=3,(SUM(AOO38,AOA38,ANM38)*(1-rof)/fee),IF(fee=4,(SUM(AOO38,AOA38,ANM38,AMY38)*(1-rof)/fee),IF(fee=5,(SUM(AOO38,AOA38,ANM38,AMY38,AMK38)*(1-rof)/fee),IF(fee=6,(SUM(AOO38,AOA38,ANM38,AMY38,AMK38,ALW38)*(1-rof)/fee),IF(fee=7,(SUM(AOO38,AOA38,ANM38,AMY38,AMK38,ALW38,ALI38)*(1-rof)/fee),0)))))))

[DonkeyOte]

I wonder if perhaps the below would work ?

Please Login or Register  to view this content.

[jm2241]

Thx for your help. I figured out the issue.