Help with formula

  • Thread starter Thread starter Noreaster
  • Start date Start date
N

Noreaster

A B C
1 360 240 50%
2 500 750 150%

With the information in A and B, how do I get the results shown in C?
I'm trying to figure efficacy of each assembly.
B is the time allotted for that product.
 
Hi,

I'm not sure you can get to those two results with one formula, they don't
seem to follow the same logic. What exactly is "efficacy" of an assembly?
And what do the number represent? Give us some detail and we might be able
to help. In the first case it looks like (360-240)/240 = 50% but that
calculation doesn't make any sense in the second case.

If you were trying to calculate efficiency, that should never be above 100%
otherwise you are violating the 2nd law of thermodynamics.

Cheers,
Shane Devenshire
 
Column A represents the amount of time in minutes it took to complete the job.
Column B represents the amount of estimated time in minutes to complete the
job, = minutes for 1 piece times the amount of pieces for the job.
I'm trying to get the efficiency compared to the estimated time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
trying to retrieve a cell from table in sheet 2 to sheet 1 1
Figuring out a lengthy formula. Probably quite simple... 3
Help with Formula 2
Formula nesting with IF statements 2
Help with countifs 1
Excel Complex Summing 3
Merging to sheets 2

Back
Top