ello all:
I have simple statistical data on an excel spreadsheet and when I try to perform calculations it, I get a #VALUE! output.
The cells to which my formula refers are formatted as numbers, so I do not know what may be happening.
It seems as if the data is not recognized as numbers. I have tried to copy and paste as value in another book but the result is the same.
Can anybody please shed light on on this matter?
Thank you!
Hi,
Your number has "." more than 1 time, use the following:-
Your attachment.....ranking cigarros Espaņa 2014.xlsx
Formula:
Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
will you please show you expected result in this case for B2,B61 and B292
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you, LokeshKumar! Any ideas on how to turn the numbers with "." into integers, getting rid of the dots?
@ nflsales: B2 = 42205775 (+ 42 millions); B61 = 982597 ; B292 = -431
Seems that after copying from the source into excel and formatting the cells as numbers without removing the dots the values get additional zeros to the right, rendering them useless
Regarding your file use this.....
Formula:Please Login or Register to view this content.
This will also work.....
Formula:Please Login or Register to view this content.
Last edited by LokeshKumar; 04-29-2015 at 06:37 AM.
Thank you, LokeshKumar! This really helps!
You Welcome.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks