Sorry if this Question is already been answered have looked quite a lot but couldn't find.
Last week at work I used this function(floor) to calc. number of for eg. 10 that comes under 100. Could you please let me know if you can give me the formula for it. So to explain properly. I give £5 to every 100th so if I have 1000 what formula to use so that it tell me the exact amount in ££? I used floor but can't remember and lost the logic and its really irritating me now. Any help on this is very much appreciated.
Last week at work I used this function(floor) to calc. number of for eg. 10 that comes under 100. Could you please let me know if you can give me the formula for it. So to explain properly. I give £5 to every 100th so if I have 1000 what formula to use so that it tell me the exact amount in ££? I used floor but can't remember and lost the logic and its really irritating me now. Any help on this is very much appreciated.