Thread: multiple if functions in 1 cell
View Single Post
 
Old 05-25-2017, 11:34 PM
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
Maybe:

=IF((A1>384)*(A1<769),A7,IF(A1>288,A6,IF(A1>192,A5 ,IF(A1>96,A4,IF(A1>0,A3)))))

If this is not what you want, please give a detailed example.
Reply With Quote