Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-25-2017, 11:34 PM
xor xor is offline multiple if functions in 1 cell Windows 10 multiple if functions in 1 cell 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple if functions in 1 cell Counting multiple data in cell more than once Alaska1 Excel 3 03-01-2015 04:27 PM
multiple if functions in 1 cell Help with creating an invoice calculator with multiple drop down menus and functions excerbated123 Excel 10 02-03-2015 03:07 PM
multiple if functions in 1 cell I need to add multiple values based on multiple criteria in a cell not sure what to do AUHAMM Excel 3 10-27-2014 09:11 PM
Multiple data in one cell? New Daddy Excel 4 09-06-2013 02:50 AM
Splitting Excel cell into multiple ruben23 Excel 1 07-23-2009 03:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 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