• 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.

How do I use the function "if"

Safequip

Safequip

Member
I have spreadsheet that has options of yes or no which dictates the end price, I want to have it auto calculate so for example if you choose the option yes it automatically shows the price but if you choose no it has a zero value. Can anyone advise on how this is done

Thanks in advance again
 
Assume Yes/No is in cell B2 and Price in C2

Then in the cell you want
=If(B2="Yes", Cell with price, 0)
=If(B2="Yes", C2, 0)
 
So for example when I put yes into say D27 I want E27 to show the price of say £9.99 but if it says no then it should be £0.00
 

Attachments

  • forum.xlsx
    30.9 KB · Views: 4
You must log in or register to reply here.
Back
Top