Variable ROUNDUP question from Formula

[Drew Terp]

I want to define an IF statement that rounds up to the nearest whole number if it is .75 or above, down to the nearest whole number if it is .25 or below, and rounds to .5 if between .26 and .74.


I6=(I3*0.5)/16

I3 (124) = 3.875

vs

C5=(C2*0.5)/16

C2 (261) = 8.15

vs

D6=(D3*0.5)/16

D3(274) = 8.56


Would appreciate any help.

Thank you.

 

[Cubist]

Maybe this

=INT(A1)+XLOOKUP(MOD(A1,1),{0,0.26,0.75},{0,0.5,1},,-1)

 

[Drew Terp]

Maybe this

=INT(A1)+XLOOKUP(MOD(A1,1),{0,0.26,0.75},{0,0.5,1},,-1)

It worked perfectly. Thank you.

 

[Cubist]

You're welcome. Cheers.

 

[smozgur]

It worked perfectly. Thank you.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.