Thanks:  0
Likes:  0

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

1. 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

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

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

Tom

3. Thanks Tom

4. 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 (%).

## User Tag List

#### Posting Permissions

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