+ Reply to Thread
Results 1 to 4 of 4

Formula to show cell F6 as 20% of cell D6

  1. #1
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Formula to show cell F6 as 20% of cell D6

    I want CELL F6 to be 20% of CELL D6. What will the formula be please?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Percentage help please

    In F6 >> =D6*0.2
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Re: Formula to show cell F6 as 20% of cell D6

    Thanks Jeff, as easy as that eh? I thought I'd have to use one of the PERCENTAGE range of calculations.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Formula to show cell F6 as 20% of cell D6

    Hi David,

    Sometimes it is as easy as that and especially if it gets you the right results.

    You're welcome…glad you have a workable solution and thanks for the feedback...

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 2
    Last Post: 11-13-2012, 03:51 PM
  2. Replies: 5
    Last Post: 02-11-2011, 08:36 AM
  3. how to Show Formula of one Cell in NEXT CELL
    By smd111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 09:52 AM
  4. need sum to show instead of formula in cell
    By Linda in forum Excel General
    Replies: 2
    Last Post: 01-24-2006, 12:25 PM
  5. [SOLVED] How to show the formula of another cell
    By Bol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2006, 10:40 AM

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