Excel

adellombard74
Occasional Visitor

Hi

I have a mark sheet of a set of marks of a group of learners. e.g.

Mark  67.8%

Sean 34.2 %

Jolene  55,8%

I want excel to identify a range and convert it in a next column to a number

e.g.  marks between 1 and 29.9 = must be converted in a new column as a 1

marks between 30 and 39.9 = must be converted in a new column as a 2

etc...

1 Reply

Hi,

 

If you define somewhere in workbook your marks ranges not to hardcode them, like on this mockup

image.png

 the formula will be

=LOOKUP(E1,$A$1:$A$9,$B$1:$B$9)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies