Formula Help Please

[Sergio_Montenegro]

I currently have this formula which works very well;

=IF($S$15=0,$S$2+$S$9-$S$14,$S$2+$S$9-$S$14+$S$11)-(2*($S$16=1))

I also have this formula wich also works well;
=('RM 1400 Tariff April 2010'!H5-('RM 1400 Tariff April 2010'!H5*('RM 1400 Tariff April 2010'!H24+'RM 1400 Tariff April 2010'!J33)))*MAX((Q5=A22),(Q5=A23)*98.6%,(Q5=A24)*MAX((Q6=A26),(Q6=A27)*98%,(Q6=A28)*95.3%))

However I wish to add -(2*($S$16=1)) from the first formula to the second formula, as below..

=('RM 1400 Tariff April 2010'!H5-('RM 1400 Tariff April 2010'!H5*('RM 1400 Tariff April 2010'!H24+'RM 1400 Tariff April 2010'!J33)))*MAX((Q5=A22),(Q5=A23)*98.6%,(Q5=A24)*MAX((Q6=A26),(Q6=A27)*98%,(Q6=A28)*95.3%))-(2*($S$16=1)))

Just adding it in this way is not working (nothing changes when S16 =1)..

Can anyone help out with this?

Thanks in advance

Serge

 

[jasonb75]

It should work if you remove the invalid closing paranthesis

=('RM 1400 Tariff April 2010'!H5-('RM 1400 Tariff April 2010'!H5*('RM 1400 Tariff April 2010'!H24+'RM 1400 Tariff April 2010'!J33)))*MAX((Q5=A22),(Q5=A23)*98.6%,(Q5=A24)*MAX((Q6=A26),(Q6=A27)*98%,(Q6=A28)*95.3%))-(2*($S$16=1)))

 

[Sergio_Montenegro]

It should work if you remove the invalid closing paranthesis

=('RM 1400 Tariff April 2010'!H5-('RM 1400 Tariff April 2010'!H5*('RM 1400 Tariff April 2010'!H24+'RM 1400 Tariff April 2010'!J33)))*MAX((Q5=A22),(Q5=A23)*98.6%,(Q5=A24)*MAX((Q6=A26),(Q6=A27)*98%,(Q6=A28)*95.3%))-(2*($S$16=1)))

Thanks very much Jason, seems so simple when someone else looks at it...