+ Reply to Thread
Results 1 to 2 of 2

Percentages multiplying problem

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Percentages multiplying problem

    Hello everyone!

    When I created a speadsheet I wanted to multiply number in a sheet( 0.5) with a percentage in a sheet (40.49) and it gives me #VALUE! error. Does someone know a solution to this problem? Interestingly I was playing around with it quite a while and I can calculate percentages like 52%*38% but cannot do the same if I add decimals( example: 51.1%*38%)

  2. #2
    Administrator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2304 (Build 16307.20006) Win 11 Home 64 Bit

    Re: Percentages multiplying problem

    Cannot replicate your issue. Suggest you post a copy of your worksheet for analysis.
    Make sure there is just enough data to demonstrate your need.
    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. problem multiplying minutes and seconds
    By bnhinton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2013, 01:30 PM
  2. [SOLVED] Having a problem with percentages
    By tom hatten in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2013, 05:47 PM
  3. Multiplying odd numbers by percentages to total to original number
    By leepea42 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-08-2013, 02:22 AM
  4. Problem with multiplying cells automatically
    By milan23 in forum Excel General
    Replies: 1
    Last Post: 03-28-2011, 02:05 PM
  5. Maths Problem With Percentages
    By luvthavodka in forum Excel General
    Replies: 1
    Last Post: 08-14-2010, 08:58 PM
  6. Percentages problem
    By Ridgy in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-27-2010, 10:25 PM
  7. Replies: 3
    Last Post: 07-22-2005, 01:05 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1