Hi there
I hope you are well!
I am trying to get a formula that will make a cell say yes or no depending on what value is selected in a drop down box.
I have attached a example spreadsheet with more information in. Please feel free to give it a go.
thanks
Mike
yes or no formula.xlsx
perhaps this?
=IF($C$6=$A$3,"Yes","No")
edit: is there an echo in here? lol
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
In E6
=IF(C6=A3,"Yes","No")
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank you. Do you know what formula would be required if there was 4 drop down boxes and if one of them had mobile selected it said yes. (same principle just more drop down boxes to base the formula on). I have tried =IF(C6:C9=A3,"Yes","No") but for some reason it does not work. Please see amended spreadsheet.
thanks
yes or no formula (updated) 2.xlsx
Last edited by mfairhurst1; 10-12-2013 at 11:39 AM.
maybe this...
=IF(COUNTIF($C$6:$C$9,A3)>=1,"Yes","No")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks