Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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