Conditional formula

T

thejudge

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
 
M

Mangesh Yadav

=IF(A1<50000,x,IF(A1<100000,y,z))

Substitute x, y and z with your formula

Mangesh
 
B

Bernie Deitrick

=IF(A1<50000,FormulaX,IF(A1<100000,FormulaY,FormulaZ))

HTH,
Bernie
MS Excel MVP
 
Top