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 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 7 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 MICKEY MOUSE 16 months ago
Dear raggededge, You can take rest you need. You have already given enough clue to make my article look better. I did enjoy your wise feedbacks. It was really helpful.Dear friends,I hope this article is not seen in a comical perspective but more in a serious tone. It talks about a man who faced...
by hanka545 8 years ago
Please email me on firstname.lastname@example.orgReally 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|