Split 100% using if statement

[renjithpl]

Hi All,

I have a percentage data, i need to split it into 4 parts, like 0% - 25%, 26%-50%, 51% - 75% and 75% - 100%.

i have tried something like = if(Percentage >=50%, 'Above 50%', 'Below 50%') it works for two split, i am struggling to give a between two numbers.

Any idea ?

Regards

Ranjit

[renjithpl · Accepted solution]

got the answer,

= if(Percentage >=0% and Percentage <=25%, 'b/w 0-25%', if(Percentage >=26% and Percentage<=50%, 'b/w 26-50%', if(Percentage>=51% and Percentage <=75%, 'b/w 51-75%, 'b/w 76-100%')

Thanks