| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4 take 2
Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add highs, mediums and lows on the spreadsheet and then give me a total in number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
High = 4 take 2
See suggestion in your other thread...
Please don't post the same question multiple times - it just tends to fragment any answers you get. In article , High = 4 take 2 <High = 4 take wrote: Someone help! I need to know how I would do this i want to creat a formula so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add highs, mediums and lows on the spreadsheet and then give me a total in number. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
High = 4 take 2
=if("a1"="High",4,if("a1"="Medium",2,1))
"High = 4 take 2" wrote: Someone help! I need to know how I would do this i want to creat a formula so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add highs, mediums and lows on the spreadsheet and then give me a total in number. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
High = 4 take 2
Did you try this? The result will always be 1
In article , Mike wrote: =if("a1"="High",4,if("a1"="Medium",2,1)) "High = 4 take 2" wrote: Someone help! I need to know how I would do this i want to creat a formula so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add highs, mediums and lows on the spreadsheet and then give me a total in number. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
High = 4 take 2
My bad try this
=IF(A1="High",1,IF(A1="Medium",2,IF(A1="Low",1,"") )) "Mike" wrote: =if("a1"="High",4,if("a1"="Medium",2,1)) "High = 4 take 2" wrote: Someone help! I need to know how I would do this i want to creat a formula so that when i type in High it will equal 4 or Medium equal 2 or low equal 1. So for example: = IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add highs, mediums and lows on the spreadsheet and then give me a total in number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| High = 4 | Excel Worksheet Functions | |||
| what does a high covariance mean? | Excel Worksheet Functions | |||
| Drop 2 high and 2 low - help! | Excel Discussion (Misc queries) | |||
| High bars | Charts and Charting in Excel | |||
| Need formula for 5 yr high/low | Excel Worksheet Functions | |||
Hybrid Mode
