I have been struggling with calculating values in Excel. I have tried both Excel 2003 and Excel 2007 but I still get a #Value error. The formula is =B2*C2*0.25*0.40*0.05. B2 is number value and C2 has dollar value. Please help me solve this as I am doing keyword research for my new website.
Someone's been reading up on TKA I see.
I think Simey and I gave you the answer the other day -- either B2 or C2 is not being recognized as a number. Did you specifically go and reformat both cells?
I did but to no avail. I still get the error.
Sid - Contact me via my profile page. I'll give you my email address (don't want to publicize it here) and maybe you can send me the spreadsheet. I'm happy to take a look at it.
Like Irohner said, make sure that both cells are recognized as numbers.
Format C2, make sure it is set to “Currency” and that the currency symbol is set to whatever currency you are using. If you are using $ in C2, make sure that the currency symbol in format is set to $.
by Enoch Kane 5 days ago
I recently updated a featured hub, and hubpages has now unfeatured the hub, saying it does not meet the quality standards
by patrickwaje 9 years ago
i have here an ipod video wherein, it was left unused for about a month. then as i tried to open and try turn it on, it wont. so i tried to charge it,for about 2 minutes, it suddenly tells that it is full charge so i guess it's finish. then as i took it off from the plug, it turned off and i doesnt...
by jasondk 6 years ago
Need your help please?What can I do that my printer drivers didn't work in my PC?Need your help please?
by sid_candid 4 years ago
I am getting an error with Microsoft excel calculation. I am using Microsoft Excel 2003 and when calculating with a formula I am getting #VALUE!. The formula is put as =C2*.25*B2*.4*.05. Please help me solve this problem.
by pinkylee 8 years ago
I am working on a hub near and dear to my heart. It's about breast cancer and I really could use your stories if you have them. I need your permission to use your picture with you having some for of pink on. This is my third attempt to get the help of all the hubbers here on hubpages. You can email...
by hanka545 8 years ago
Please email me on email@example.comReally need your help! Have a dissertation to write on...Indian Caste system..I would really like some help deciding on the specific chapters, and exactly to concentrate on, within the vast topic of Indian cinema...I'm interested to know, why Art cinema...
|HubPages Device ID|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Google Analytics|
|HubPages Traffic Pixel|
|Google Hosted Libraries|
|Google AdSense Host API|
|Conversion Tracking Pixels|
|Author Google Analytics|
|Amazon Tracking Pixel|