Conditions
 

How can I put 3 conditions in one formula

Conditions
 

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

Conditions
 

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

Conditions
 

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,"value15")))

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

--
Rick (MVP - Excel)


"zvroom" wrote in message
...
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