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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

Excel VBA 1
Formulas displayed in cell rather than calculated values? 4
Concatenating two text strings, formula is right, cell output is w 3
Formula changes to answer within the cell or some variation 4
Use & with two formulas 2
Select a range not equal to: 4
Vlookup and return sheet name also 2
formula finds values in apparently blank cells 1

Back
Top