if/then question

  • Thread starter Thread starter Brendan Quirk
  • Start date Start date
B

Brendan Quirk

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
 
Brendan

this should work

=IF(A5>=A4,0,(A3-A5)*A2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top