Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditions
How can I put 3 conditions in one formula
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Conditions | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |