Hi forum,
I'm looking to create a IF formula for my database. There's a universal number produced in my table that which can be described by text. I would like this text to show in my table when the numbers are generated.
Here's the key and text to be shown for when the number value is generated.
100 - Group 1
98 - Group 2
96 - Group 3
94 - Listed
92 - Heritage
88 - Class 2
84 - Class 3
80 - Class 4
77 - Class 5
73 - Class 6
68 - Class 7
So for example in my table on Excel, if I had figures 77, 84, 88 then it should show "Class 5", "Class 3" and "Class 2"
Bookmarks