High = 4 take 2

  • Thread starter High = 4 take 2
  • Start date
H

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.
 
J

JE McGimpsey

See suggestion in your other thread...

Please don't post the same question multiple times - it just tends to
fragment any answers you get.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF/AND/OR Statements 0
Formula: Counting Cells on Different Worksheets 3
High = 4 7
If value between 2 numbers 7
Estimates with multiple look ups 1
PivotTable - Filter Row 0
Set up a count and countif? 2
Link a text box based on drop down box with four options MS Word 365 0

Top