Then try this:

=F6*CHOOSE(MATCH(F6,{-1E+300,10,20,30,40}),15,7,6,5,3)

The -1E+300 could be be replaced with any value that is less than the
smallest possible value in F6.

/ Lars-Åke


On Sun, 23 Nov 2008 04:45:02 -0800, john
wrote:


sorry ,if the value goes below 10 it needs to be 15x f6
"Lars-Åke Aspelin" wrote:

On Sun, 23 Nov 2008 03:53:00 -0800, 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

Is this want you want?

If the value in cell F6 is 40 or more you would like the formula to
return the value in cell F6 multiplied by 3
If the value in cell F6 is 30 or more (but less than 40) you would
like the formula to return the value in cell F6 multiplied by 5
If the value in cell F6 is 20 or more (but less than 30) you would
like the formula to return the value in cell F6 multiplied by 6
If the value in cell F6 is 10 or more (but less than 20) you would
like the formula to return the value in cell F6 multiplied by 7.

You have not defined what result you want if the value in cell F6 is
less than 10, so we assume that this will never happen.

Try this formula:

=F6*CHOOSE(MATCH(F6,{10,20,30,40}),7,6,5,3)

Hope this helps / Lars-Åke