Can anyone tell me why the following formuls won't work?
=IF(C3>0,IF(B3=$I$1,($J$1-C3)*$I$1),IF(B3=$I$2,($J$2-C3)*$I$2),IF(B3=$I$3,($J$3-C3)*$I$3),IF(B3=$I$4,($J$4-C3)*$J$4),IF(B3=$I$5,($J$5-C3)*$J$5),IF(B3=$I$6,($J$6-C3)*$J$6),"")
I get an error saying i hve entered too many arguments
Many Thanks!
=IF(C3>0,IF(B3=$I$1,($J$1-C3)*$I$1),IF(B3=$I$2,($J$2-C3)*$I$2),IF(B3=$I$3,($J$3-C3)*$I$3),IF(B3=$I$4,($J$4-C3)*$J$4),IF(B3=$I$5,($J$5-C3)*$J$5),IF(B3=$I$6,($J$6-C3)*$J$6),"")
I get an error saying i hve entered too many arguments
Many Thanks!