can anyone one help me work this out? i have six possible scenarios and not
sure what formula to use. I have a base of 125000 (b20) and six possible
outcomes, first is between a and b (b16). a will equal 90% and b will equal
80% of the 125,000. i then have three other outcomes to go with this.
1,2,3(b17). option 1 will not change anything, option 2 will add a further
20000 to the answer and option 3 will add 40000 to the answer. i can't seem
to get this into one formula, i either get an incorrect or too many
arguments. any help would be greatly appreciated.