Forum Discussion

Bradley79's avatar
Bradley79
Copper Contributor
Feb 18, 2020

IFS with AND and multiple falses

    I am trying to write a IFS statement using a drop down box to select a product to generate a commission amount to fill into the box.   So I have 4 products lets say they are auto, home, life ...
excel
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 18, 2020

Bradley79 

If product in A1 and enrollment in B1

formula could be

=LOOKUP(A1,{"accident","auto","home","life"},IF(B1<1,{8,5,10,7},{4,2,3,0}))

But better not to hardcode constants, put them in ranges instead.