Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical formulas in excel
What I'd like to do is create a set of conditional statements. If the cell
a1="cat", then the number in a2*.25. If the cell a1="dog", then the number in a2*.75. A1 will always say dog or cat. The then part of the statement changes based on the text. Any suggestions on how to accomplish this? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical formulas in excel
youve aready cracked it.If cell a1 will only ever have cat or dog all you
need is +if(A1="Cat",A2*.25,A2*.75).Type this in A3(or any other cell excpet a1 or a2 This test is not case sensitive -- paul remove nospam for email addy! "c.welch" wrote: What I'd like to do is create a set of conditional statements. If the cell a1="cat", then the number in a2*.25. If the cell a1="dog", then the number in a2*.75. A1 will always say dog or cat. The then part of the statement changes based on the text. Any suggestions on how to accomplish this? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical formulas in excel
In A2, type:
IF(A1="cat",.25,.75) HTH -- AP "c.welch" a écrit dans le message de ... What I'd like to do is create a set of conditional statements. If the cell a1="cat", then the number in a2*.25. If the cell a1="dog", then the number in a2*.75. A1 will always say dog or cat. The then part of the statement changes based on the text. Any suggestions on how to accomplish this? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical formulas in excel
"c.welch" wrote: What I'd like to do is create a set of conditional statements. If the cell a1="cat", then the number in a2*.25. If the cell a1="dog", then the number in a2*.75. A1 will always say dog or cat. The then part of the statement changes based on the text. Any suggestions on how to accomplish this? Thanks. Thanks for your quick response Paul! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |