Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4
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
One way:
=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low") In article , Formulas 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
Another way...
=MATCH(A1,{"Low","Medium","`","High"},0) Rick "Formulas" wrote in message ... 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
JE McGimpsey wrote...
One way: =4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low") .... Variation, =SUMPRODUCT(COUNTIF(A:A,{"High";"Medium";"Low"}),{ 4;2;1}) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4
Hi,
I think this will work but i wouldn't know where to start it in the spreadsheet? Thanks, "JE McGimpsey" wrote: One way: =4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low") In article , Formulas 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4
Hi,
I think this will work but i wouldn't know where to start it in the spreadsheet? Thanks, "Harlan Grove" wrote: JE McGimpsey wrote... One way: =4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low") .... Variation, =SUMPRODUCT(COUNTIF(A:A,{"High";"Medium";"Low"}),{ 4;2;1}) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4
Hi,
Can i send you the part of the spreadsheet i am trying to do? The formula seems like it will work but i am not to sure how to use it. Thanks, "JE McGimpsey" wrote: One way: =4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low") In article , Formulas 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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
High = 4
Sending the workbook isn't really necessary - and my filters would kill
your message anyway. Just enter the formula in a cell, changing "A:A" to the range you're interested in. In article , High = 4 take 2 wrote: Can i send you the part of the spreadsheet i am trying to do? The formula seems like it will work but i am not to sure how to use it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for High Value | Excel Worksheet Functions | |||
what does a high covariance mean? | Excel Worksheet Functions | |||
high and low value in a cell | Excel Discussion (Misc queries) | |||
High bars | Charts and Charting in Excel | |||
Need formula for 5 yr high/low | Excel Worksheet Functions |