Forum Discussion
vernp80
Sep 06, 2019Copper Contributor
Need help with advanced IF/AND nested formula (too many arguments)
Hi all, I'm stuck with a fairly advanced (at least to me) nested IF/AND formula. I have a formula like this: =IF(AND(B18="Onshore (US)",B8="Social Sciences",B35="Simple"),Rate_Card!E20 with ...
SergeiBaklan
Sep 07, 2019Diamond Contributor
vernp80 , if Rate_Card is organised as a matrix for all possible combination when INDEX/MATCH or like shall work.