Forum Discussion
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),(...
=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.
=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.
Thanks for the suggestion!