Need help with figuring out a formula please

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

I think I found my problem and it seems to be working now. Can someone
verify for me this is correct? BTW... The actual cells I referenced before
were for example purposes only, the cells referenced here are accurate.

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


Thanks,
David

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

Hi!

Try this:

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

I guess you're formatting the cell as Percentage ?

Biff

"DavidJ726" <[email protected]> wrote in message
news:%[email protected]...
> My bad... It's not working :-(
>
>

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

David

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> Try this:
>
> =1-(O12*16+P12)/(O11*16+P11)
>
> I guess you're formatting the cell as Percentage ?
>
> Biff
>
> "DavidJ726" <[email protected]> wrote in message
> news:%[email protected]...
>> My bad... It's not working :-(
>>
>>
>
>

You're welcome. Thanks for the feedback!

Biff

"DavidJ726" <[email protected]> wrote in message
news:[email protected]...
> Thanks Biff, That's exactly what I needed. Yeah, the cell is formatted as
> a percentage.
>
> David
>
> "Biff" <[email protected]> wrote in message
> news:[email protected]...
>> Hi!
>>
>> Try this:
>>
>> =1-(O12*16+P12)/(O11*16+P11)
>>
>> I guess you're formatting the cell as Percentage ?
>>
>> Biff
>>
>> "DavidJ726" <[email protected]> wrote in message
>> news:%[email protected]...
>>> My bad... It's not working :-(
>>>
>>>
>>
>>
>
>