excelismagic
asked on
how can this IF formula be simplified
i have this formula, the A1 contains another formula which results to some percentage value.
how can the below formula be simplified?
how can the below formula be simplified?
=IF(A1>0.35,"FirstCheck",IF(A1>0.35,"SecondCheck",IF(A1>0.35,"ThirdCheck",IF(A1>0.35,"ForthCheck",IF(A1>0.35,"FifthCheck",IF(A1>0.35,"SixthCheck",""))))))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
All the logical conditions are checking 0.35 in A1 in your formula.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@MacroShadow
SWITCH function is available in 2016. Hope asker is using 2016 so he can test this.
SWITCH function is available in 2016. Hope asker is using 2016 so he can test this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks alot