|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 2nd, 2009, 07:36 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
April 2nd, 2009, 10:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
April 3rd, 2009, 07:37 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
April 6th, 2009, 10:12 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#5
April 6th, 2009, 10:52 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need help with formula
Hi Kerri
With the number in A1 try this formula in B1: =IF(A124,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 -
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
