WHAT-IF function....

[r3born]

Does anyone know another short function to do what-if? because when i use the what-if function its too long, and i like to know if there some other way to do it n it short....

[Dav]

You have to be a bit more specfic in what you want to achieve. A way round nested if statements that can get long is to include a vlookup to reference a table

Eg instead of if 1 red, if 2 blue, if 3 orange, if 4 green

would be if the following table was in a1:b4 and the value was in d1
vlookup(d1,a1:b4,2,false)

Obviously with more values this becomes more useful, but unless you give us an example it is hard to be anything less than general

Regards

Dav

[r3born]

=D32*IF(D32<=9,1150,IF(D14<=29,1100,IF(D32<=49,1050,IF(D32>=50,950))))

I like to make this shorter, is there anyway doing it by not using the What-If function...

[kraljb]

I'm assuming the D14 doesn't need to be there, but what you may want to try is the following...

Create a list that reads

A;B
0;1150
10;1100
30;1050
50;950

Then change the formula to read

=G32*INDEX($B$1:$B$4,MATCH(G32,$A$1:$A$4,1),0)

OR

=G32*VLOOKUP(G32,$A$1:$B$4,2)