Multiple If Formula Help

Platform discussions
1

Hello

Need help as trying to do a multiple if formula for the following.

If a number column has a certain number in it i want to then classify it

<5 = Basic
5.01-10 = Low
10.01-25 = Mid

25 = High

I have tried many things and its just not working as its different to excel! Can someone help me?

2

@bspence1,

IF({num}<=5,"Basic",IF({num}<=10,"Low",IF({num}<=25,"Mid","High")))
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.