Hi,

Thank you for taking the time to reply. I am sorry for writing a too
general question. What I meant was:

if a value is between 0 and 5, then divide x amount by y, if the value is
between 5.001 and 10 then divide x amount by z, and if the value is between
10.001 and 15 then divide x amount by w,


"Bernard Liengme" wrote:

What sort of formula? IF, SUMPRODUCT....
Please tell us what you want to do
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"zvroom" wrote in message
...
How can I put 3 conditions in one formula