formula code to give a score

Joined
Nov 21, 2016
Messages
32
Hi All,

I was wondering if you could help me.

I have a value in cell B2 I would like cell C2 to give a score of either 1,2 or 3 depending on cell B2

So, If B2 score was >4.9, C2 = 3

If B2 was Between 4.8 - 4.4, C2 = 2

If B2 was <4.4, C2 = 1

I'm not very good at this so I was wondering if there was an easy solution?

Thank you I really appreciate any help on this!

Cheers
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,099,034
Messages
5,466,146
Members
406,470
Latest member
Darshan Shah

This Week's Hot Topics

Top