CODEWITHSUNDEEP
excelexcel-formula
user4259224
user4259224

Reputation: 27

excel roundup if number is 2 or greater and/or less than 2

In Excel I am using the following formula to round off numbers to 0.5:

=IF((ROUNDUP(F5,1))-(ROUNDDOWN(F5,0))>0.5,ROUNDUP(F5,0),ROUNDDOWN(F5,0)+0.5)

The issue I have is, I would like the formula to see any values of '2' or greater to round up to the next '0' rather than '0.5'. For example, 1.25 rounds up to 1.5 & 2.11 rounds up to 3.

I would appreciate anyone's assistance here.

Upvotes: 1

Views: 3112

Answers (1)

Steven Martin
Steven Martin

Reputation: 3282

The CEILING Function is best in this situation , it allows for significance of the roundup, 2 of them coupled with an IF will sort this out

=IF(F5<2,CEILING(F5,0.5),CEILING(F5,1))

Upvotes: 1

Related Questions