Hi,
Can anyone help me building the if statement as below logic?
Can anyone help me building the if statement as below logic?
| If logic with multiple criteria.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Amount | Comments | Status (Yes/No) | ||||||
| 2 | $0 | yes | logic to build | if Amount is >0, then "yes", and if amount is equal to 0 and comments column is not blank then "yes", otherwise "no" | |||||
| 3 | $1,000 | ||||||||
| 4 | $0 | ||||||||
| 5 | $350 | ||||||||
| 6 | $40,000 | ||||||||
| 7 | $0 | yes | |||||||
| 8 | $200 | ||||||||
| 9 | $1,500 | ||||||||
| 10 | $1,010 | ||||||||
| 11 | $70,000 | ||||||||
| 12 | $0 | ||||||||
| 13 | $0 | no | |||||||
| 14 | $800 | ||||||||
| 15 | $0 | ||||||||
| 16 | $0 | ||||||||
| 17 | $20,500 | ||||||||
| 18 | $0 | ||||||||
| 19 | $1,500 | ||||||||
| 20 | $0 | aaa | |||||||
| 21 | $2,100 | ||||||||
Sheet1 | |||||||||
