how to apply condition to dispaly the row below

rashnash2011

New Member
Joined
Feb 25, 2011
Messages
3
Hi ALL,

I am trying to build a excel test in which i wanted to add a feature where depending the cell value the next row should be displayed.

Eg: 1) Have you attended the BI training - Yes

In this case if you select "Yes" then in the next row the 2nd question should be displayed

2) What was the course duration? - No

In this case if you select "No" then no value should be written in the next row:confused:
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Depending on how easy/complex you want this to be you could either use IF statements (easy) or VB (more complex).

A simple IF statement would be - assuming your quesiton one is in cell A1 and answer in B1 then in cell A2 =if(b1="yes","What was the course duration?","")

You can nest a few more of these in here if you want
 
Upvote 0
Depending on how easy/complex you want this to be you could either use IF statements (easy) or VB (more complex).

A simple IF statement would be - assuming your quesiton one is in cell A1 and answer in B1 then in cell A2 =if(b1="yes","What was the course duration?","")

You can nest a few more of these in here if you want

I tried this formula but it was not returning any value. And where i need to place this formula

The set of questions are as follows:
Extraction of teleservices SRs - Yes
Categorization of the SRs in the track - Yes
Completing the questions for BRD - Yes
Identification of stakeholders - No

Then if "No" is returned then no more questions are displayed.
 
Upvote 0
Are you sure? It is working for me! You can do this for each question and once "No" is chosen the quotes ("") in the formula will mean it displays nothing

=if(<the cell the question is in>="yes",<"your next question">,"")
 
Upvote 0
Are you sure? It is working for me! You can do this for each question and once "No" is chosen the quotes ("") in the formula will mean it displays nothing

=if(<THE in is question the cell>="yes",<"your next question">,"")


Can you please tell me where i need to put this formula in the excel???
 
Upvote 0

Forum statistics

Threads
1,224,504
Messages
6,179,142
Members
452,892
Latest member
JUSTOUTOFMYREACH

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
Back
Top