Trying to get a formula where any decimal number above 1 will round the next highest whole number (examples: .33 will round to 1, 1.33 will round to 2, 3.23 will round to 4, etc.). I also need if the formula = a negative it displays a 0 as opposed to -4.
current formula using and somewhat working
=MAX(IF([Paper Towels]2 / [Paper Towels]1 - [Paper Towels]3 > 0.4, [Paper Towels]2 / [Paper Towels]1 - [Paper Towels]3 + 0.4, [Paper Towels]2 / [Paper Towels]1 - [Paper Towels]3), 0)
current Data: Paper Towels2 = 40, Paper Towels1 = 30, Paper Towels3 = 1
40(paper towel 2) / 30 (paper towel 1) = 1.33
1.33 - 1 (paper towel 3) = .33
I need .33 to round to 1 and I'm stuck. tried the if formula with adding .04 to get it over but not working correctly.
Thanks for any help
