I'm having a problem combining formulas:
For example, IF F3 <0.25, then ROUNDUP, 0.25, then if F3 >=0.25, but <1.0, ROUNDUP to next 0.5.
Where cell contains value 0.2 - it should round up to 0.25
Where cell value contains 0.6 - it should round up to 1.0
Where cell value contains 1.2 - it should round up to 1.5
HOW???
Bookmarks