Forum Discussion

mfree0107's avatar
mfree0107
Copper Contributor
Apr 26, 2022
Solved

IF FORMULA ERROR MESSAGE "YOU'VE ENTERED TOO MANY ARGUMENTS FOR THIS FUNCTION"

TRYING TO ADD ONE MORE CONDITION "(IF($I2="CONC W REBAR",($O2)," TO THIS FORMULA   =IF($H2="cw",(IF($I2="ASPHALT",($O2),(IF($I2="BRICKS",($O2),(IF($I2="CONCRETE",($O2),(IF($I2="DIRT/GRAVEL",($O2),(...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Apr 26, 2022

    mfree0107 

    =IF($H2="cw",IF($I2="ASPHALT",$O2,IF($I2="BRICKS",$O2,IF($I2="CONCRETE",$O2,IF($I2="DIRT/GRAVEL",$O2,IF($I2="CONC W REBAR",$O2,""))))),"")

    Does this work in your sheet? I removed some " ( " and " ) " which makes the formula easier in my opinion.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 26, 2022

mfree0107 

It is also possible to reformulate the formula to reduce the level of nesting,

=IF(code="cw",
   SWITCH(material,
      "ASPHALT",      return,
      "BRICKS",       return,
      "CONCRETE",     return,
      "DIRT/GRAVEL",  return,
      "CONC W REBAR", return,
   ""),
"")

or

= IF(code="cw",
     IF(
        OR(material={"ASPHALT","BRICKS","CONCRETE","DIRT/GRAVEL","CONC W REBAR"}),
        return,
     ""),
  "")

The latter would require a Lambda helper function if it were to be used as an array formula over 'code' and 'material'.

 

Resources