Need help rounding up - THX Mike/Thomas for previous answer
One more question for you, if p53=2.35 but is not m53/.85, the if command
is still answering 2.35 since it ends in .05. How can I get it to go up to
2.40?
"Mike H" wrote:
Hi,
You don't need the quotes or the = sign
=IF(P53M53/0.85,P53,CEILING(P53,0.05))
|