Hello
I want populating value in adjacent cell in column F based on column C or D ,if one of columns C or D contains value bigger zero ,then should populate the value in adjacant value in column F ,otherwise should populate zero whether contains column C,D together zero or empty .
thanks
I want populating value in adjacent cell in column F based on column C or D ,if one of columns C or D contains value bigger zero ,then should populate the value in adjacant value in column F ,otherwise should populate zero whether contains column C,D together zero or empty .
Maklil.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ITEM | BRAND | PURCHASE | SALES | BALANCE | FORMULA | ||
2 | 1 | ref-air1000 | 11 | 0 | 110 | 11 | ||
3 | 2 | ref-air1001 | 0 | 10 | 220 | 10 | ||
4 | 3 | ref-air1002 | 0 | 0 | 300 | 0 | ||
5 | 4 | ref-air1003 | 0 | 0 | 100 | 0 | ||
6 | 5 | ref-air1004 | 11 | 110 | 11 | |||
7 | 6 | ref-air1005 | 200 | 0 | ||||
sheet1 |
thanks