I need help dragging a formula down
Tarabull,
Try replacing CEILING with ROUNDUP.
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.
"tarabull" wrote:
The resulting answer is 2.35 in both cases when i use the formula that Thomas
gave. Since 2.35 ends in .05, the ceiling of .05 keeps it at 2.35
"Thomas [PBD]" wrote:
Those were the answers that I returned with the current situations and formula.
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.
"tarabull" wrote:
in situation #1, i would want answer to be 2.35
in situation #2, i would want answer to be 2.40
"Mike H" wrote:
Hi,
I'm confused
M53 =1
P53=2.35
What answer do you expect?
M53=999
P53 =2.35
What answer do you expect?
Mike
"tarabull" wrote:
but i need it to round up to the nearest .05, say if p53 was 2.30 but not
m53/.85 then i would need it to equal 2.35
"Mike H" wrote:
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?
|