excel formula to convert a number between 0-5 as 5 and 5-10 as 10 etc-CodePudding

Home > database > excel formula to convert a number between 0-5 as 5 and 5-10 as 10 etc

excel formula to convert a number between 0-5 as 5 and 5-10 as 10 etc

Time：03-23

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?

CodePudding user response：

Try the int formula =(INT(C5/5) 1)*5

Page link：https//www.codepudding.com/database/345142.html

Prev:How to group by a second ID column in Power Query

Next:How to insert a blank row based on cell value

Tags：

excel

Links：
CodePudding