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" <aledger@discussions.microsoft.com> wrote in message
news:6D448A66-73A7-4148-BABC-DA0DD5F21F4C@microsoft.com...
> 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 <6D448A66-73A7-4148-BABC-DA0DD5F21F4C@microsoft.com>,
"aledger" <aledger@discussions.microsoft.com> 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" <jemcgimpsey@mvps.org> wrote in message news:jemcgimpsey-2E9BCB.10461403032005@msnews.microsoft.com...
> It would be helpful if you posted the formula...
>
> In article <6D448A66-73A7-4148-BABC-DA0DD5F21F4C@microsoft.com>,
> "aledger" <aledger@discussions.microsoft.com> 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.

I don't see an answer to this thread. The following formula works in I6 and J6 of my spreadsheet but gives me a #VALUE! error in K6, L6, M6 and so on. I have checked the format to make sure it is set to General and automatic calculation is enabled. Any suggesstions?

=IF('PM Coord.'!E6:J6=""," ",'PM Coord.'!J6)

Hello yreddic, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.