A B C D
1 $25 YES NO
I am trying to write a formula based on the above table as follow:
On cell D I want the result based on thi formula: If B equal to "Yes" calculate A*10%, if B="Yes" AND C="NO", calculate A*20%,otherwise leave the celle blank (or return $0.00) if B is blank.