Need Conditional formula

fishin

Board Regular
Joined
Jan 18, 2009
Messages
184
Need a formula to address the following:
If cell E10 on a worksheet identified as “CandidateSelection” = “C” and cell G6 on that same worksheet is not blank, post thevalue “Y” to the recipient cell….if these conditions are not met, the recipientcell is to remain blank.

Help is appreciated

 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
does this work?

In the recipient cell enter: =if(and(E10="C", G6<>""),"Y","")
 
Upvote 0
excellent, delighted to have helped and thanks for the feedback.
 
Upvote 0
excellent, delighted to have helped and thanks for the feedback.

Hello...Yesterday in response to a request for a conditional formula you provided the following: =if(and(E10="C", G6<>""),"Y","") Iresponded with a thank you indicating that the formula you provided worked..... well it appears I was mistaken and would appreciate if you would re-examine the formula as it relates to my needs and see if you can determine what the problem is.

I repeat the original request here: If cell E10 on a worksheet identified as “Candidate Selection” = “C” and cell G6 on that same worksheet is not blank, post the value “Y” to the recipient cell….if these conditions are not met, the recipient cell is to remain blank.

Although I'm not certain, I think the problem may be that the recipient cell is located on one worksheet while the conditional data is located on another worksheet identified as "Candidate Selection".

Once again, your help will certainly be appreciated.
 
Upvote 0
Apologies, now that I've reread your original post the formula should be: =if(and('Candidate Selection'!E10="C", 'Candidate Selection'!G6<>""),"Y","")
 
Upvote 0
Apologies, now that I've reread your original post the formula should be: =if(and('Candidate Selection'!E10="C", 'Candidate Selection'!G6<>""),"Y","")

No need for apologies. I truly appreciate your response. The adjusted version works perfectly. Thanks agsain.

Regards,

Dave
 
Upvote 0
Hi Dave, no problems. For info, this is a relatively straightforward problem in excel (though I accept that's easy to say when you know how!). The following steps would have created this formula and the technique can be used almost everywhere.

1. in the 'recipient cell' start typing (don't press Enter until indicated below): =if(and(
2. click on cell E10 on the 'Candidate Selection' sheet
3. type: ="C",
4. click on cell G6 on the 'Candidate Selection' sheet
5. type: <>""),"Y","")
6. Press ENTER

You should then have created the formula.

Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

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