| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula help required
I am looking for a single formula for excel 2003 to do the following:
If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then A10=400. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula help required
The formula goes in the cell where the result is to appear, A10 in your case.
=if(A1="R",400/0.99,if(A2="H",400/0.9,400)) "TomGill" wrote: I am looking for a single formula for excel 2003 to do the following: If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then A10=400. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula help required
=IF(A1="R",400/0.99,IF(A"="H",400/0.9,400))
and put that in A10 -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "TomGill" wrote in message ... I am looking for a single formula for excel 2003 to do the following: If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then A10=400. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula help required
I am looking for a single formula for excel 2003 to do the following:
If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then A10=400. One way is to put this in A10 =400/IF(A1="R",0.99,IF(A1="H",0.9,1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula date | Excel Worksheet Functions | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| conditional formatting with formula | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
