Formula assistance please

[SirSmee]

Hi,

I have a formula used to calculate my waiters' commissions. This formula (below) automatically removes VAT.
A recent system upgrade renders this useless, so I would like to change the formula to use the exact amount entered. Please assist, as this is a multi-page formula.

=+IF(+SALES!H6>0,(+IF((SALES!H6-SALES!H6*14%)*(SALES!$C6/100)<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6/100)),0)<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6 p 100)),0)<><SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6 p 100)),0)<>

 

[SirSmee]

=+if(+sales!h6>0,(+if((sales!h6-sales!h6*14%)*(sales!$c6/100)<sales!$e6,sales!$e6,(sales!h6-sales!h6*14%)*sales!$c6/100)),0)

 

[tweedle]

What Part of your formula represents "VAT"?

Is this formula complete? The parenthetics aren't closed.

=+IF(+SALES!H6>0,(+IF((SALES!H6-SALES!H6*14%)*(SALES!$C6/100)<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6 p 100)),0)< 100)),0)<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6><SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6 p 100)),0)<>

 

[SirSmee]

Formula doesnt fully paste:
=+IF(+SALES!H6>0,(+IF((SALES!H6-SALES!H6*14%)*(SALES!$C6/100)<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6/100)),0)

 

[SirSmee]

The rest:
<SALES!$E6,SALES!$E6,(SALES!H6-SALES!H6*14%)*SALES!$C6/100)),0)

 

[SirSmee]

Never mind, cancel the thread. It isn't pasting.

 

[Special-K99]

On this board, insert spaces before and after any "<" ">" characters when posting and it will appear correctly.

 

[SirSmee]

On this board, insert spaces before and after any "<" ">" characters when posting and it will appear correctly.

Thanks, I didn't know that