Here's what I hope is a pretty basic question.
I have 5 rows of inventory data. They are the following:
A1: Product Name
A2: Product Cost
A3: Maximum Qty. Desired on Hand
A4: Minimum Qty. Desired on Hand
A5: Quantity on Hand
Basically, it looks like this:
Widget X | 25 | 10 | 4 | 5
I'd like to figure out how to write a formula for cell A6 that would tell me
the following:
If A5 is greater or equal to A4, then I'd like A6 = 0.
If A5 is less than A4, then I'd like A6 = (A3-A5) * A2.
Is this possible?
Many thanks, Brendan
Nick Hodge - 30 Jan 2005 21:59 GMT
Brendan
this should work
=IF(A5>=A4,0,(A3-A5)*A2)

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> Here's what I hope is a pretty basic question.
>
[quoted text clipped - 20 lines]
>
> Many thanks, Brendan
Brendan Quirk - 31 Jan 2005 00:54 GMT
That did it! Many thanks for the quick and perfect advice!
> Brendan
>
[quoted text clipped - 26 lines]
>>
>> Many thanks, Brendan