Thread: [Solved] if(and.. formula
View Single Post
 
Old 05-19-2016, 08:02 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Pecoflyer gave you by far the best formula (one function call), but if you absolutely want to use a complicated IF(AND-construction with a lot more function calls then:
Attached Files
File Type: xlsx paxon_2.xlsx (14.7 KB, 10 views)
Reply With Quote