+ Reply to Thread
Results 1 to 2 of 2

Put amount in cell B, multiplied by 11, yet leaving the number I input viewed

Hybrid View

  1. #1
    Registered User
    Join Date
    12-07-2008
    Location
    Orlando,FL
    Posts
    1

    Put amount in cell B, multiplied by 11, yet leaving the number I input viewed

    I have excel 2007
    I'm not sure if excel can do this, if so it's beyond my figuring it out.
    I need to input a dollar amount into cell A
    I need to input another dollar amount into cell B, which is automatically multiplied by 11, yet leaving the number I input viewed,and then added to the value of cell A and automaticlly entered into cell C.
    Cell D needs to contain 5% of cell C
    Cell E needs to contain Cell D subtracted from Cell C.

    If any of this makes sense and you can help....It will be much appreciated
    Last edited by VBA Noob; 12-07-2008 at 03:49 PM.

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    In Cell C1 enter the below formula

    =B1*11+A1
    In Cell D1 enter
    =C1 * 5%
    In Cell E1 enter
    =C1 - D1

+ 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