Need help with figuring out a formula please

[DavidJ726]

Thanks for the help!

I may be going about this the wrong way, but this is what I'm trying to
do...

I have two colums A=Lbs B=Ozs.
I have two rows. 2= Pre 3=Post

I need to show in Cell B5, the loss percentage.

If I start out with 2 lbs 6 ozs and I end up with 1 ld 15 oz, how do I
figure the formula?

When I was working with oz's only it was easy, all I did was =1-(B3/B4) But
I'm having a heck of a time figuring out the sequence to conver lbs into
ozs. add teh result with the value in the oz's, and then figure out the loss
%.

Any help is appreciated.
David

 

[DavidJ726]

My bad... It's not working :-(

 

[Biff]

Hi!

Try this:

=1-(O12*16+P12)/(O11*16+P11)

I guess you're formatting the cell as Percentage ?

Biff

 

[DavidJ726]

Thanks Biff, That's exactly what I needed. Yeah, the cell is formatted as a
percentage.

David

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thanks Biff, That's exactly what I needed. Yeah, the cell is formatted as
a percentage.

David