How to minus 5% within 'mmult' please?

**jackhulk** · 08-21-2011, 05:24 PM

Hello

I have the following....

=MMULT(G3,H3)-H3-K3-M3-O3

...and would like to deduct 5% from the final total, but can't figure out how?

Thank you

**shg** · 08-21-2011, 05:29 PM

=0.95*(MMULT(G3,H3)-H3-K3-M3-O3)

Or, since MMULT is unnecessary,

=0.95*((G3-1)*H3-K3-M3-O3)

**jackhulk** · 08-21-2011, 05:33 PM

Fantastic! Thank you!

**jackhulk** · 08-22-2011, 07:41 AM

Hello again.

I've like to add an IF statement to this if possible.

I'd like the deduct 5% only if total figure is positive. I've created IF statement...

=IF(P3<0,P3,P3*0.95)

.... but not sure how or if it's possible to incorporate into existing formula as I think its a circular reference?