'excel formula to convert a number between 0-5 as 5 and 5-10 as 10 etc
I want to write a logic in excel that if value in a call is between 0 and 5 then the cell takes value as 5, if it is between 5 and 10 then the value taken is 10 and so on. How can I do this?
Solution 1:[1]
Try the int formula =(INT(C5/5)+1)*5
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | MrT |