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 sid_candid3 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 MICKEY MOUSE4 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...
by pinkylee7 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...
Copyright © 2017 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.