Discussion Need help with advanced IF/AND nested formula (too many arguments) in Excel
https://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/841215#M39543
<P>Hi all,</P><P>I'm stuck with a fairly advanced (at least to me) nested IF/AND formula. I have a formula like this:</P><P> </P><P>=IF(AND(B18="Onshore (US)",B8="Social Sciences",B35="Simple"),Rate_Card!E20</P><P> </P><P>with the first three arguments coming out of my current tab, and the last coming from a second tab ("Rate_Card"). The formula snippet above is actually only one section of 13...ergo, I have 39 arguments in just my original cell. That actually works fine, and I get one of 13 desired results correctly.</P><P> </P><P>My problem is that I need to modify this formula to also offer results with "simple" replaced with either "moderate" or "complex", which then gives me roughly a page and a half of formulas, and an error that I have too many arguments. In other words, I can't triple the size.</P><P> </P><P>I've looked at various options online, and can't seem to find a viable alternative to the formula I'm using. Any ideas would be SO appreciated!</P><P> </P>Fri, 06 Sep 2019 16:12:00 GMTvernp802019-09-06T16:12:00ZNeed help with advanced IF/AND nested formula (too many arguments)
https://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/841215#M39543
<P>Hi all,</P><P>I'm stuck with a fairly advanced (at least to me) nested IF/AND formula. I have a formula like this:</P><P> </P><P>=IF(AND(B18="Onshore (US)",B8="Social Sciences",B35="Simple"),Rate_Card!E20</P><P> </P><P>with the first three arguments coming out of my current tab, and the last coming from a second tab ("Rate_Card"). The formula snippet above is actually only one section of 13...ergo, I have 39 arguments in just my original cell. That actually works fine, and I get one of 13 desired results correctly.</P><P> </P><P>My problem is that I need to modify this formula to also offer results with "simple" replaced with either "moderate" or "complex", which then gives me roughly a page and a half of formulas, and an error that I have too many arguments. In other words, I can't triple the size.</P><P> </P><P>I've looked at various options online, and can't seem to find a viable alternative to the formula I'm using. Any ideas would be SO appreciated!</P><P> </P>Fri, 06 Sep 2019 16:12:00 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/841215#M39543vernp802019-09-06T16:12:00ZRe: Need help with advanced IF/AND nested formula (too many arguments)
https://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/842100#M39565
<P><LI-USER uid="404803"></LI-USER> </P><P>Please identify all possible combinations of B8, B18, and B35, along with your desired result for each combination. </P>Sat, 07 Sep 2019 05:31:33 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/842100#M39565Twifoo2019-09-07T05:31:33ZRe: Need help with advanced IF/AND nested formula (too many arguments)
https://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/842407#M39584
<P><LI-USER uid="404803"></LI-USER> , if Rate_Card is organised as a matrix for all possible combination when INDEX/MATCH or like shall work.</P>Sat, 07 Sep 2019 15:51:16 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-advanced-if-and-nested-formula-too-many-arguments/m-p/842407#M39584Sergei Baklan2019-09-07T15:51:16Z