+ Reply to Thread
Results 1 to 4 of 4

Change a percentage formula

  1. 07-03-2012, 12:41 PM #1
    shug1986
    shug1986 is offline
    Registered User
    Join Date
    07-03-2012
    Location
    SC, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Change a percentage formula

    I am attaching the spreadsheet so you can see what I am talking about. I need to change the service charge percentage rate in cells F4:F10 from 2.75% to 3.25% for all customers. The total new balance in cell G11 should equal $2,919.01. Can you tell me how to do this? Thank you so much.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2012, 01:19 PM #2
    dilipandey
    dilipandey is offline
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Change a percentage formula

    Hi Shug,

    Welcome to the forum.

    Where you have calculated the service charge percentage i.e., 2.75% ?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]
    Reply With QuoteRegister To Reply
  3. 07-03-2012, 03:20 PM #3
    shug1986
    shug1986 is offline
    Registered User
    Join Date
    07-03-2012
    Location
    SC, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Change a percentage formula

    I am just learning the program.My problem is I don't remember where or how I did that. Can you help me?
    Reply With QuoteRegister To Reply
  4. 07-04-2012, 02:29 PM #4
    dilipandey
    dilipandey is offline
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Change a percentage formula

    Hi Shug,


    I just saw and find some figures are getting added.. and if you need to change the percentage then I require this information...


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1