Formula Problem

[Will_D]

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!

 

[Scott Huish]

EDIT: Misread post

 

[Michael M]

What about
=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,"")))))))

Regards
Michael M

 

[Will_D]

Thanks Michael that works!

 

[Michael M]

Glad to hear, thanks for the feedback.

Michael M