Help!!!

[nganguyen303]

Hi,

I have a calculation to do. The formula is (on hand/sold quantity)*30.
However, on top of that, if on hand= 0 and sold quantity = 0 , then the answer should be 0.
if on-hand >=1 and sold quantity = 0, then the answer should be 30.

How do I write one whole formula to express this?

 

[gsistek]

Using A1 as Sold Quantity and B1 as On Hand...
=IF(A1=0,IF(B1=0,0,IF(B1<1,30,(B1/A1)*30)),(B1/A1)*30)

 

[VoG]

Perhaps

=IF(AND(A1=0,B1=0),0,MAX(30,30*(A1/B1))

 

[gbell3587]

Hi,

I have a calculation to do. The formula is (on hand/sold quantity)*30.
However, on top of that, if on hand= 0 and sold quantity = 0 , then the answer should be 0.
if on-hand >=1 and sold quantity = 0, then the answer should be 30.

How do I write one whole formula to express this?

if on-hand = 0 And sold-qty = 0 then
result = 0
else
result = (on-hand/sold-qty) * 30
end if

 

[nganguyen303]

Using A1 as Sold Quantity and B1 as On Hand...
=IF(A1=0,IF(B1=0,0,IF(B1<1,30,(B1/A1)*30)),(B1/A1)*30)

Thank you! It worked!

 

[gsistek]

Happy to help! Though, personally I think VoG's formula is easier to understand/use.