Originally Posted by
AlmostAGeek
The sum in V57 should be either a total of S21 and V51 OR S26 and V51 OR S28 and V51.
I think you need to elaborate on the above such that we can follow the logic... ie what is/are the rules to determine which of S21,S26,S28 are to be added to V51 ?
On an aside... you can dispose of your lengthy double IF in S28 by using a LOOKUP, eg instead of:
S28:
=IF(P28=1,725,IF(P28=2,1000,IF(P28=3,1300,IF(P28=4,1650,IF(P28=5,2000,IF(P28=6,2400,IF(P28=7,2850,IF(P28=8,3350,))))))))+IF(P28=9,3900)
use:
S28:
=LOOKUP(P28,{0,1,2,3,4,5,6,7,8,9},{0,725,1000,1300,1650,2000,2400,2850,3350,3900})
If you post back we can wrap this up quite quickly I suspect.
Bookmarks