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"