kalpeshkansara
New Member
- Joined
- Dec 15, 2016
- Messages
- 43
If I need any rupees amount of figures in fixed figure like (25 - 50 - 75 - 100)only for every any amount.
(Here we take 25,50,75,100 as criteria)
How can we do in excel with using some formulas?
i.e. If I have figures like odd in amount as below than?
Odd - even
101 - 125 - If I get odd figures 101 than formula will set that amount to 125 because odd figure is below than 25 criteria and more than 100+1. so
126 - 150 - If I get odd figures 126 than formula will set that amount to 150 because odd figure is more than 25 criteria and more than 125+1. so
149 - 150 - If I get odd figures 149 than formula will set that amount to 150 because odd figure below than 50 criteria and more than 125. so
151 - 175 - If I get odd figures 151 than formula will set that amount to 175 because odd figure below than 75 criteria and more than 150. so
169 - 175 - If I get odd figures 169 than formula will set that amount to 175 because odd figure below than 75 criteria and more than 150. so
176 - 200 - If I get odd figures 176 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175+1. so
181 - 200 - If I get odd figures 181 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175. so
199 - 200 - If I get odd figures 199 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175. so
219 - 225 - If I get odd figures 219 than formula will set that amount to 225 because odd figure below than 25 criteria and more than 200. so
342 - 350 - If I get odd figures 342 than formula will set that amount to 350 because odd figure below than 50 criteria and more than 325. so
356 - 375 - If I get odd figures 356 than formula will set that amount to 375 because odd figure below than 75 criteria and more than 350. so
881 - 900 - If I get odd figures 881 than formula will set that amount to 900 because odd figure below than 900 criteria and more than 875. So
Like this all figures we have to set odd figures like magnetic to 25,50,75,100 respectively as we get amounts.
This we need to set all in 5 digits figures too.
i.e.
If we get odd figure 34876 then its formula will set to 34900.
If we get odd figure 11738 then its formula will set to 11750
I need help for this.
(Here we take 25,50,75,100 as criteria)
How can we do in excel with using some formulas?
i.e. If I have figures like odd in amount as below than?
Odd - even
101 - 125 - If I get odd figures 101 than formula will set that amount to 125 because odd figure is below than 25 criteria and more than 100+1. so
126 - 150 - If I get odd figures 126 than formula will set that amount to 150 because odd figure is more than 25 criteria and more than 125+1. so
149 - 150 - If I get odd figures 149 than formula will set that amount to 150 because odd figure below than 50 criteria and more than 125. so
151 - 175 - If I get odd figures 151 than formula will set that amount to 175 because odd figure below than 75 criteria and more than 150. so
169 - 175 - If I get odd figures 169 than formula will set that amount to 175 because odd figure below than 75 criteria and more than 150. so
176 - 200 - If I get odd figures 176 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175+1. so
181 - 200 - If I get odd figures 181 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175. so
199 - 200 - If I get odd figures 199 than formula will set that amount to 200 because odd figure below than 200 criteria and more than 175. so
219 - 225 - If I get odd figures 219 than formula will set that amount to 225 because odd figure below than 25 criteria and more than 200. so
342 - 350 - If I get odd figures 342 than formula will set that amount to 350 because odd figure below than 50 criteria and more than 325. so
356 - 375 - If I get odd figures 356 than formula will set that amount to 375 because odd figure below than 75 criteria and more than 350. so
881 - 900 - If I get odd figures 881 than formula will set that amount to 900 because odd figure below than 900 criteria and more than 875. So
Like this all figures we have to set odd figures like magnetic to 25,50,75,100 respectively as we get amounts.
This we need to set all in 5 digits figures too.
i.e.
If we get odd figure 34876 then its formula will set to 34900.
If we get odd figure 11738 then its formula will set to 11750
I need help for this.
Last edited: