I need help dragging a formula down
You *asked* for the text string.
That's what the quote marks do in the formula.
If you don't want it as a text string, don't put it inside quote marks. You
don't need the equals sign either.
--
David Biddulph
"tarabull" wrote in message
...
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?
|