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.
What are the values of c2 and b2? If there is a 'blank' in one of them you possibly will get this error - replace a blank with zero.
I note that this formula works for me when i place a value in both cells; the only way I replicate the error is by entering text into one of the cells.
Solve given error out owing to xlsx viewer, more details you may know at XLSX Viewer Tool set
Next writing http://www.xlsx.viewertool.com/ contains all the needed solutions
No none of the columns are empty. C2 is currency and B2 is a number.
I think what Simey's trying to say is that it's probably not recognizing one of the cells as numerical. Go into both C2 and B2 and use the format, number stuff (can't remember where it is in 2003) to format them.
Yes it has a currency sign before the amount or numbers though it is not in dollars.
If you typed the currency sign directly in to the cell then remove the currency sign and use the 'number formatting' to format as the currency...hmmm I just typed in the $ before numbers and that works too....check to see if there is the character ' before the currency sign....
There was a dot between the currency sign and the number removed it but no use.
No no its not confidential. Its a keyword research excel sheet. And the currency values are in Rs which is the symbol for Indian rupees. I can send it but you have Excel 2007 not sure if the excel sheet will open properly in your computer.
I believe all Office products are backwards compatible. In other words you can open a document in Office 2007 that was written in 2003, but not the other way round.
IzzyM is right - I can open it and save it as an Excel 2003 format...
Just send you an email. Please have a look.
Just sent the file back to you:
-I used edit replace to remove the 'rs.'
-I saved as an excel file rather than the comma delimited file.
-I added the formula - only the values remained in the file you sent me
Hope this helps
you can try to use parenthesis or brackets and at the same time make sure you are giving the correct cell references
by Taleb AlDris 7 years ago
I am an accountant, so sure I should use Excel for doing some job.Day by day, I get more from it & enjoy saving my time using it.Please, if you have any question, let me know, may I help.
by frugalisto 6 years ago
How do you turn off Microsoft Excel Full Screen?I'm using the latest version of excel and it is full screen. I cannot see the menu bar.
by richardcha 2 years ago
How to recover a corrupt Microsoft Excel fileHi,Accidently I deleted my user profile along which all my data in the desktop and profile documents got lost. My support guy did restore the files of the profile using a recovery tool. But I found that some office files (Excel,Word and Powerpoint) open...
by meah890890 9 years ago
how can i get a compete Microsoft excel formula list
by Taleb AlDris 8 years ago
What would you like to learn any thing in Microsoft Excel?I will do my best to help.
Copyright © 2019 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.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|