Hi Team,
Need your help to check Outstanding amount Column A,
should be between -250 or +250, and Column B value Sap Balance.
should be between -250 or +250
if condition met , update column C. shown in below Table.
Thanks for your help in advance
Thanks
mg
Need your help to check Outstanding amount Column A,
should be between -250 or +250, and Column B value Sap Balance.
should be between -250 or +250
if condition met , update column C. shown in below Table.
Book10 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Outstanding Balance | SAP Balance | Remark | Criteria to Decide Coumn C as follows | ||
2 | -250 | 150 | Condition met | O/s Balance and SAP Bal Amount should be between + or – 250 | ||
3 | -251 | 200 | Condition met | |||
4 | 265 | 250 | Condition not met | |||
5 | -365 | -100 | Condition not met | |||
6 | 0 | 300 | Condition not met | |||
7 | -250 | 250 | Condition Met | |||
8 | 100 | -400 | Condition not met | |||
9 | 200 | Condition not met | ||||
Sheet1 |
Thanks for your help in advance
Thanks
mg