• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I NEED HELP WRITING THIS FORMULA FOR SPREADSHEET THAT I AM WORKING ON

P

Papitou

New Member
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:

Code: 
=IF(AND(B1="Yes",C1="No"),A1*20%,IF(AND(B1="Yes",C1<>"No"),A1*10%,0))
 
You must log in or register to reply here.
Back
Top