Choosing from 2 formulas for one cell
 

I need to use one of two formulas for one cell. I need the cell to either
figure 10% or 5% of another cell depending on the data I enter. Is there a
way to save formulas and then choose which one I want to use for that cell?

Choosing from 2 formulas for one cell
 

use if condition

= if(data=1,formula_1,formula_2)

e.g.:

if(A1=1,0.05*A2,0.1*A2)

Mangesh



"rechan" wrote in message
...
I need to use one of two formulas for one cell. I need the cell to either
figure 10% or 5% of another cell depending on the data I enter. Is there
a
way to save formulas and then choose which one I want to use for that
cell?