What is the formula to round UP a number in half increment (.5).
example:
From 2.25 To 2.50
From 1.65 To 2.00
From 3.10 To 3.50
What is the formula to round UP a number in half increment (.5).
example:
From 2.25 To 2.50
From 1.65 To 2.00
From 3.10 To 3.50
Hi,
Try =ROUNDUP(A1/0.5,0)*0.5
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks