Tarabull,

Mike H has the answer to that. You are returning the string
=ceiling(P53,0.05) and not the result of it. Basically, Mike stated, that
your formula should be
=IF(P53M53/0.85,P53,CEILING(P53,0.05))

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"tarabull" wrote:

actually this if command isn't working... if p53 is NOT greater than
m53/.85, then i am not getting the NUMBER ceiling(p53,.0.05) I am getting the
text "ceiling(p53,0.05)"

how can i get the false result to =ceiling(p53,0.05)??

"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?