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

A

aledger

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.
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Drop down list control value in vba 2
Hide columns based on row values 2
3 IFs argument in one formula 2
Excel help needed: Skipping cell without skipping cell reference 1
Vlookup and return sheet name also 2
Use & with two formulas 2

Top