Tick boxes result in yes/no result
Hi all,
I am looking for a solution for my sheet. The 4 tick boxes in H:K must all be ticked for column M to show 'Yes' if less than 4 are ticked then it shows no. Column M shows the desired outcome. I require the tick boxes down to row 380.
Any advice would be much appreciated.
Oliver
Last edited by Oliver3443; 08-29-2024 at 05:38 AM.
Your check boxes need to be linked to their cells via properties.
Alternatively, if you are on the 365 beta channel (insider), you could use the new tick boxes on the Home ribbon.
Then use this:
=IF(COUNTIF(H3:K3,TRUE)=4,"YES","NO")
Last edited by AliGW; 08-29-2024 at 04:50 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you Ali, rep added.
You're welcome.
Alternative - eliminates the need for tick-box maintenance.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks