An easy one for someone I am sure :-)

[c_c_c1]

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.

 

[Legacy 98055]

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

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

Tom

 

[c_c_c1]

Thanks Tom

 

[Aladin Akyurek]

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