Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-28-2019, 07:31 AM
Debaser's Avatar
Debaser Debaser is offline IF/IFS Help Windows 7 64bit IF/IFS Help Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

I'd suggest you use something like this:

=MIN(IF(H5=TRUE,1E100,D5),IF(P5=TRUE,1E100,L5),IF( H21=TRUE,1E100,D1),IF(P21=TRUE,1E100,L21))

which will return 1E100 (a very big number) for any cells where the checkbox is TRUE. If the end result is 1E100, then none of the items are available, which you could add an additional test for if it could happen?
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 02:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft