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.
Papitou
Firstly, Welcome to the Chandoo.org Forums
Give the following a try:
=IF(AND(B1="Yes",C1="No"),A1*20%,IF(AND(B1="Yes",C1<>"No"),A1*10%,0))
You must log in to post.
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
Subscribe
