Home |
Search |
Today's Posts |
#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. |
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 |