yes and no answers

I have two codes which can be combined in one with yes no function. Code is runed to create a new email, where one code will request approval to create purchase order and other just request creating PO without approval. Both codes copy contents from tabs to create email body and select list of...

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

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

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

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

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

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: