Conditional format/IF question

[mick1222]

Hi all, I am trying to find the correct formula for an inventory issue.

If the min qty (cell N1) is not numeric (I will be using DS for items I don't have in stock) then the carrying cost (cell M1) will equal 0. If the min qty (cell N1) is numeric then the carrying cost (cell M1) will equal my cost (cell J1) times * the min qty (cell M1)

Thanks for your help! I'm a newbie with excel formulas.

mIcK

 

[Aladin Akyurek]

Hi all, I am trying to find the correct formula for an inventory issue.

If the min qty (cell N1) is not numeric (I will be using DS for items I don't have in stock) then the carrying cost (cell M1) will equal 0. If the min qty (cell N1) is numeric then the carrying cost (cell M1) will equal my cost (cell J1) times * the min qty (cell M1)

Thanks for your help! I'm a newbie with excel formulas.

mIcK

Try in M1...

=IF(N(N1),N1*J1,0)

There is some confusing reference to M1 and N1 in your description: I took M1 to be the formula cell and N1 as the cell housing Qty value. Adjust to suit.

 

[mick1222]

Oh yeah... Oops. sorry the carrying cost is cell N1. I will try that.

Thanks for your help.

 

[mick1222]

I did totally screw that up. Sorry.

Here's what it is.

J1= Cost K1=Retail L1=margin % M1=Minimum Quanity N1=Carrying cost

If my min qty (M1) is DP (drop ship) then carrying cost (N1) will be zero. If there is a numeric value in min qty (M1) then my carrying cost (N1) will equal Cost (J1) * Min qty (M1).

N1=?

 

[Aladin Akyurek]

It's actually N1 that is the formula cell. I'm trying to make it so the carrying cost automatically calculates. If I'm doing a drop ship then I won't carry the inventory so my carrying cost will be zero.

Thanks,

mIcK

You are welcome.

 

[scottylad2]

IF(M1="DP",0,IF(ISNUMBER(MinCost),Cost*MinCost))

maybe

 

[Aladin Akyurek]

I did totally screw that up. Sorry.

Here's what it is.

J1= Cost K1=Retail L1=margin % M1=Minimum Quanity N1=Carrying cost

If my min qty (M1) is DP (drop ship) then carrying cost (N1) will be zero. If there is a numeric value in min qty (M1) then my carrying cost (N1) will equal Cost (J1) * Min qty (M1).

N1=?

=IF(M1="DP",0,J1*M1)

or...

=IF(N(M1),J1*M1,0)

 

[mick1222]

Way cool! That worked.

Thank you very much everyone.

mIcK