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 patrickwaje8 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...
by jasondk6 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 pinkylee8 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...
by sid_candid4 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...
by hanka5457 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,...
by MICKEY MOUSE9 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...
Copyright © 2018 HubPages Inc. and respective owners.
Other product and company names shown may be trademarks of their respective owners.
HubPages® is a registered Service Mark of HubPages, Inc.
HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.