need help with formula
 

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

need help with formula
 

Where do I find the difference

"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

need help with formula
 

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

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

need help with formula
 

Hi Kerri

With the number in A1 try this formula in B1:

=IF(A1<24,A1*22,24*22+(A1-24)*33)


Regards,
Per

On 6 Apr., 23:12, Kerri Olsen
wrote:
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- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -