i want to set my electricity bill formula if get 1002 units bill then i want 7535 amt in one cell, i unable to set logical condition so please help me my units rate as per following
Units
0-100 3.36
101-300 6.05
301-500 7.92
501-1000 8.78
1001 and above 7.50