Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formula
I need to apply a formula to a cell which uses the value from another
cell...... ok so far! The problem is the formula can be different depending on the value of that other cell. i.e if the cell value of A1 is <50000 i need to apply formula x if the cell value of A1 is 50000 but <100000 i need to apply formula y if the cell value od A1 is 100000 i need to apply formula Z Can anyone guide me to the correct method to apply this formula? Thanks in advance |
#2
|
|||
|
|||
=IF(A1<50000,x,IF(A1<100000,y,z))
Substitute x, y and z with your formula Mangesh "thejudge" wrote in message ... I need to apply a formula to a cell which uses the value from another cell...... ok so far! The problem is the formula can be different depending on the value of that other cell. i.e if the cell value of A1 is <50000 i need to apply formula x if the cell value of A1 is 50000 but <100000 i need to apply formula y if the cell value od A1 is 100000 i need to apply formula Z Can anyone guide me to the correct method to apply this formula? Thanks in advance |
#3
|
|||
|
|||
=IF(A1<50000,FormulaX,IF(A1<100000,FormulaY,Formul aZ))
HTH, Bernie MS Excel MVP "thejudge" wrote in message ... I need to apply a formula to a cell which uses the value from another cell...... ok so far! The problem is the formula can be different depending on the value of that other cell. i.e if the cell value of A1 is <50000 i need to apply formula x if the cell value of A1 is 50000 but <100000 i need to apply formula y if the cell value od A1 is 100000 i need to apply formula Z Can anyone guide me to the correct method to apply this formula? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine conditional format with formula ? | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
conditional formatting formula | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |