Hi Lenita,

More or less of what?

Concider this:

F G H
1 materials price
2 100 200 base
3 65 194 less
4 100 200
5 135 208 more
6 300 240 more

The formula in H3 is
=((MROUND(F3;10)-$F$2)/1000+1)*$G$2

MROUND is in the add-in Analysis Toopak.

Frans

"Lenita" wrote in message
om...
Need some help with a formula. Here is the calculation I need to do:

For every $10 more, 1% more on the price
For every $10 less, 1% less on the price

Any help is appreciated.