IF and OR function

[Guest]

Hi Folks

I am trying to write a formulae that will make my life easy
What I need to do is thi
Purchases Opening Stock Total sold in the month Sold in the month from opening sold in the month from Purchas
5 0 3 ? (0) ? (3
0 10 8 ? (8) ?(0

I have tried using various forms of 'If' functions.....but it is not giving me what I want shown in brackets above
Can anyone please help with a formulae that will automate this for me

Many thank

Yinka

 

[Frank Kabel]

Hi
give the following a try (assuming FIFO)
in cell D1 (sold from purchase)
=MIN(B1,C1)

in E1 use
=B1-MIN(B1,C1)

copy both formulas down

 

[JulieD]

Hi Yinka

I think this works

Purchase Opening Stock Total Sold in Month Total Sold from Opening Total
Sold from Purchases
5 0 3
=IF(C2<=B2,C2,B2) =IF(D2<C2,C2-D2,0)
0 10 8
=IF(C3<=B3,C3,B3) =IF(D3<C3,C3-D3,0)
5 5 8
=IF(C4<=B4,C4,B4) =IF(D4<C4,C4-D4,0)

Cheers
JulieD

Hi Folks,

I am trying to write a formulae that will make my life easy!
What I need to do is this
Purchases Opening Stock Total sold in the month Sold in the month

from opening sold in the month from Purchase

5 0 3

? (0) ? (3)

0 10 8

? (8) ?(0)

I have tried using various forms of 'If' functions.....but it is not

giving me what I want shown in brackets above.