To edit value in Excel cell using IF statement

[Jangrina]

Hi,

I want to edit a value in a certain cell.
The situation goes like this;
Case 1:
Let's say the value is 7.0, so the value remains 7.0
Case 2:
Let's say the value is 7.333 which is lesser than 7.5 but greater than 7.0, so the value is changed to 7.5.
Case 3:
Let's say the value is 7.5, so the value remains 7.5.
Case 4:
Let's say the value is 7.667 which is greater than 7.5 but lesser than 8.0, so the value is changed to 8.0

How to make those cases possible in Excel? Pls, help.

 

[FormR]

Hi, welcome to the board!

Sounds like this maybe..

Excel 2013/2016
	A	B
1	7	7
2	7.333	7.5
3	7.5	7.5
4	7.667	8
Sheet1

Cell Formulas
Range	Formula
B1	=CEILING(A1,0.5)

 

[Jangrina]

Thank you very much. It works superbly!
I thought I would have to use VBA command.. but just a ceiling solves everything..