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

Need help rounding up - THX Mike/Thomas for previous answer
 

There's no need for another thread, go back to the other one, you have an
answer there

"tarabull" wrote:

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

Need help rounding up - THX Mike/Thomas for previous answer
 

sorry

"Mike H" wrote:

There's no need for another thread, go back to the other one, you have an
answer there

"tarabull" wrote:

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

Need help rounding up - THX Mike/Thomas for previous answer
 

Just trying to keep the forums clean I see.
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Mike H" wrote:

There's no need for another thread, go back to the other one, you have an
answer there

"tarabull" wrote:

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