Extract value for numbers

[tanwarrahul1988]

First Example:

Total = 1000

A1 = 200 (Fix Value)
A2 = 200 ( Fix Value)
A3 = 600 Rest balance

Second Example:

Total Amount 325

A1= 200 (Fix Value)
A2 =125
A3 = 0

 

[ETAF]

B4 = =IF(B2<=200,B2,200)
B5 = =IF(B2<=400,B2-B4,200)
B5 = =B2-B4-B5
copy all to E and H

 

[bosco_yip]

Or,

[B4]: =MIN(200,B2)

[B5]: =MIN(200,B2-B4)

[B6]: =B2-B4-B5

Regards

 

[tanwarrahul1988]

Thanks guys. Both of you resolve my query thanks a lot buddy

 

[ETAF]

you are welcome