How come my formulas work in one cell but not the other?
 

I copied formulas in one cell to the next and I'm not getting the same
result. It shows the same exact formula but doesn't return the same value.

Look at the format, if you have general format it will show all decimals
while if you have numeric with let's say 2 decimals it will display (note
display only, underlaying value is the same) a rounded value with 2 decimals

--

Regards,

Peo Sjoblom


"aledger" wrote in message
...
I copied formulas in one cell to the next and I'm not getting the same
result. It shows the same exact formula but doesn't return the same value.

It would be helpful if you posted the formula...

In article ,
"aledger" wrote:

I copied formulas in one cell to the next and I'm not getting the same
result. It shows the same exact formula but doesn't return the same value.

It would be helpful if you posted the formula...

and the address and values of that formula and
for the copied formula, and how you copied the formula.

What result you got and what you expected.

Some information on using the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JE McGimpsey" wrote in message ...
It would be helpful if you posted the formula...

In article ,
"aledger" wrote:

I copied formulas in one cell to the next and I'm not getting the same
result. It shows the same exact formula but doesn't return the same value.