Hi Vijay
Try This
=If [ number]>=0 and [ number]<=7 Then "0-7" ElseIf [ number]>=8 and [ number]<=15 Then "8-15" ElseIf [ number]>=16 and [ number]<=22 Then "16-22" ElseIf [ number] >=23 and [ number]<=29 Then "23-29" ElseIf [ number]>=30 Then "30"
Please put screenshot if this is also not working.
~Anuj
Add comment