Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: An easy one for someone I am sure :-)

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI there - a friend suggested I try this out. I am a new user of excel and am using a worksheet set up by a previous user. Here goes:

    I have figures for the amounts of jobs done and then for the amount of times we revisted to retreat.

    I need to calculate the % of retreats against total jobs done.

    Cell H has total job figure

    Cell J has number of retreats

    Can you suggested a formula to calculate % of retreats.

    eg: Cell H = 307

    Cell J = 5

    THank you for your help.




  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the following formula in the cell of your choice...

    =TEXT(J10/H10,"##.#%")

    Tom

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tom

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,033
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-27 23:13, TsTom wrote:
    Use the following formula in the cell of your choice...

    =TEXT(J10/H10,"##.#%")

    Tom
    When H10 is zero or empty, this formula will give you trouble; moreover, the result will be text-formatted, a fact that will complicate using the result in further computations. I'd suggest using:

    =IF(H10,J10/H10,0)

    Format the cell of this formula as percentage (%).

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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