yes and no answers

  1. J

    "Yes" "No" Feedback

    I'm creating a spreadsheet to detail the fire door ratings based on the fire strategy and a physical survey. A straight forward exercise where the door is not fire rated (NFR), fire rated for 30/60 minutes (FD30/FD60) or fire rated for 30/60 minutes with a smoke seal (FD30S/FD60S). I want to...
  2. 2

    Chart with Yes/No answers....

    Hi, I'm currently developing a dashboard involving 6 questions with Yes or No answers, and there are three lots of these questions per month of the year. The dashboard is in relation to 6 call quality questions in a call centre, so the three lots means three calls a month. 6 questions per...
  3. 2

    Chart with Yes/No answers across 6 questions & 12 months of the year

    Hi, I'm currently developing a dashboard involving 6 questions with Yes or No answers, and there are three lots of these questions per month of the year. How best can I present this information in a graph or chart? Every attempt so far has failed & I hope someone can help me find a solution...
  4. The_Rock

    Help with vlookup formula

    Hi Folks I'm trying to use the following formula but it keeps defaulting to the value if false i.e. "" =IF(ISNA(VLOOKUP(J8,$A$2:$F$14,6,FALSE))="CISTWE Reject","Rejected","") Basically, in the column that its looking up, there are three values. I only want it to show 'rejected' if the result...
  5. D

    Set Focus to Combo Box Based on Yes/No Message

    I have a form to populate data/dates for testing. There are two sections for testing: Test Plan Development (TPD) and System Testing (ST). Each section can have one of four statuses: Upcoming, Active, On Hold, or Complete. Each section also has a Begin Date and an End Date. The fields on...
  6. B

    Yes and No values

    I want to make a formula that says if cell B2 has the word "yes" typed in it then cell d10 will equal "5" and if cell B2 has the word "no" typed in it then cell d10 will equal "1". I am a novice. Help!:confused:

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top