+ Reply to Thread
Results 1 to 2 of 2

Multiplying then dividing the result of the multiplication

  1. #1
    Registered User
    Join Date
    08-08-2010
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Multiplying then dividing the result of the multiplication

    What I am needing is a formula to list the result of multiplying cell A1 by.75 in cell B1, and then divide cell B1(the result of A1) by 52, which the result will be in Cell C1. For example:

    Cell A1 is $50,000, and it is the only cell that has information typed in on the sheet. I enter the formula I need. Now Cell B1 shows $37,500( or 50,000x .75), and Cell C1 shows 721.15( or 37,500 /52).

    The formula I am asking for will fill B1 and C1 with the appropriate information.

    Any help would be great.

    Thanks,

    CB

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,079

    Re: Multiplying then dividing the result of the multiplication

    You have already solved your own problem. Just replace the succeeding dollar values by the cells from which they come. E.g. Cell A1 is $50,000,... Cell B1 shows $37,500( or 50,000x .75) ===> in B1:
    Please Login or Register  to view this content.
    etc
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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