Hi,

Although you can do this type of problem with a nested if, if there were too
many IF's Excel would not be happy, so its probably good practice to consider
another solution, and one that give a lot of flexibility in the long run is
VLOOKUP. In this case create a lookup table in a range, say C1:D5 as follows

-10000 7
10 6
20 5
30 3
40 1

The -10000, just replace that with the smallest number you would ever get in
your data.

The the formula would be

=F5*VLOOKUP(F5,C$1:D$5,2,1)

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
"john" wrote:

=if(f6<56.16, f6*7.2,f6*7.9/2)

hi all
the above formula calculates f6, when less it does the far calculation
otherwise it performs the other,what i really want is for f6 to have 4 points
of reference from f6< 40 multply x3 ,from30x5 ,from 20 multiply 6 ,from 10
multiply x7
any help please
thanks john