I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

I need help dragging a formula down
 

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?

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?

I need help dragging a formula down
 

Then it rounds it up to 3.00

"Thomas [PBD]" wrote:

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?

I need help dragging a formula down
 

My mistake, ROUNDUP(P53,1)
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"tarabull" wrote:

Then it rounds it up to 3.00

"Thomas [PBD]" wrote:

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?

I need help dragging a formula down
 

nope, still 3.00

"Thomas [PBD]" wrote:

My mistake, ROUNDUP(P53,1)
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"tarabull" wrote:

Then it rounds it up to 3.00

"Thomas [PBD]" wrote:

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?

I need help dragging a formula down
 

That's odd. I run it on mine and it says 2.35 Roundup(P53,1) = 2.4

I get three when I put .1 in the second criteria...

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


"tarabull" wrote:

nope, still 3.00

"Thomas [PBD]" wrote:

My mistake, ROUNDUP(P53,1)
--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"tarabull" wrote:

Then it rounds it up to 3.00

"Thomas [PBD]" wrote:

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?