Calculating a Formula on a Single Line

[Fabbyfil]

Hi

I have a relatively simple formula but woiuld like to calculate it in 1 formulation,

Total Level 3 Over 12 min
5,855 121 216

I want to calculate the the % of bags after deducting the Level 3 & Over 12 min bags

i.e. Total bags - Level 3 = 5734
5734 - Level 3 = 5518
5518 / Total Bags = 94.2%

How can I put the following into a line formula

Many Thanks

[jasoncw]

Assuming the numbers are in B2, B3, and B4, try:

=(B2-B3-B4)/B2

HTH,
Jason

[Fabbyfil]

Ja

Thanks for the reply but that is the incorrect result.

That formula would give for example

6,289 - 228 - 99 / 6,289 = 94.8%

but if I calculate it the following way :

6,289 - 228 = 6061
6061 - 99 = 5962
5962 / 6061 = 98.3%

It's the above I would like in one formula if possible


Thanks

[jasoncw]

Ok, try this:

=(B2-B3-B4)/(B2-B3)

Jason

[zbor]

Or =1+B4/(B3-B2)

Wich is same as jason write but nicer

Wich can be adjusted into: =IF(B3=B2;"";1+B4/(B3-B2))

[Fabbyfil]

All

Excellent, just what I wanted thank you