Help-Getting error with Microsoft Excel calculation

Jump to Last Post 1-7 of 7 discussions (18 posts)
  1. sid_candid profile image61
    sid_candidposted 7 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.

    1. SimeyC profile image95
      SimeyCposted 7 years agoin reply to this

      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.

    2. profile image49
      ryanwesselsposted 4 years agoin reply to this

      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

  2. sid_candid profile image61
    sid_candidposted 7 years ago

    No none of the columns are empty. C2 is currency and B2 is a number.

    1. SimeyC profile image95
      SimeyCposted 7 years agoin reply to this

      It works for me on Excel 2007 - I note the Excel auto changed the formula to:

      =C2*0.25*B2*0.4*0.05

      perhaps Excel 2003 doesn't add the extra zero and this is causing the problem?

  3. lrohner profile image81
    lrohnerposted 7 years ago

    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.

    1. SimeyC profile image95
      SimeyCposted 7 years agoin reply to this

      *light bulb* - the currency amount - did you enter a '$' or whatever symbol in front of the numbers? That would change it to text - to view as currency you should format as currency and not enter the symbol!

  4. sid_candid profile image61
    sid_candidposted 7 years ago

    Yes it has a currency sign before the amount or numbers though it is not in dollars.

    1. SimeyC profile image95
      SimeyCposted 7 years agoin reply to this

      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....

  5. sid_candid profile image61
    sid_candidposted 7 years ago

    There was a dot between the currency sign and the number removed it but no use.

    1. SimeyC profile image95
      SimeyCposted 7 years agoin reply to this

      If you want - send the Excel worksheet (if it's not confidential) to me and I'll take a look.

      simeycook@hotmail.com

  6. sid_candid profile image61
    sid_candidposted 7 years ago

    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.

    1. IzzyM profile image87
      IzzyMposted 7 years agoin reply to this

      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.

      1. SimeyC profile image95
        SimeyCposted 7 years agoin reply to this

        IzzyM is right - I can open it and save it as an Excel 2003 format...

        1. sid_candid profile image61
          sid_candidposted 7 years agoin reply to this

          Just send you an email. Please have a look.

          1. SimeyC profile image95
            SimeyCposted 7 years agoin reply to this

            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

            1. sid_candid profile image61
              sid_candidposted 7 years agoin reply to this

              Thanks for your help Simon but I am still getting the error in a new excel sheet. This time its Excel 2007.

  7. Palnatech profile image73
    Palnatechposted 4 years ago

    you can try to use parenthesis or brackets and at the same time make sure you are giving the correct cell references

 
working

This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

Show Details
Necessary
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis 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.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
Features
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Marketing
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe 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 PixelsWe 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.
Statistics
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)