Conditions

  • Thread starter Thread starter zvroom
  • Start date Start date
What sort of formula? IF, SUMPRODUCT....
Please tell us what you want to do
best wishes
 
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,
 
Your description is still kind of general (no cell references); however,
assuming value, x, y, z and w are defined names...

=IF(value<=5,x/y,IF(value<=10,x/z,IF(value<=15,x/w,"value>15")))

You didn't say what you wanted if value is greater than 15, so I just used a
text message for that condition.
 
Back
Top