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.

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.

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.

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.

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.