need help with formula
if the # in cell is 35
result would be 24*22 + 11*33=891
if the # in cell is 10
result would be 10*22=220
I am not understanding how to create an if equation
--
Kerri
"Jerry W. Lewis" wrote:
See Help for "IF worksheet function"
I can't be more specific without a better description of the alternative
calculations.
Jerry
"Kerri Olsen" wrote:
how to write a formula?
if cell =24 multiple by 22. if cell is <24, multiply 24 by 22, multiply
difference by 33 add together
--
Kerri
|