Maybe

=IF(P53M53/0.85,P53,CEILING(P53,0.1))


Mike

"tarabull" wrote:

Thanks Mike,

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))

Mike

"tarabull" wrote:

I am using:

=IF(P53M53/0.85,P53,"=ceiling(P53,0.05)")

if I copy and paste down, ceiling(p53,0.05) doesn't change to p54, p55, p56
etc... what do i need to do to make this happen?