Array Help Please!!

[August]

Book1
	A	B	C	D	E
1				Tax Liability
2	Name	Expenses	Tax Rate	Benefit	Tax
3	J Smith	1,500.00	30%	2,142.86	642.86
4	P Jones	12,000.00	20%	15,000.00	3,000.00
5	A Boot	5,000.00	40%	8,333.33	3,333.33
6		18,500.00		25,476.19	6,976.19
7
8	Taxable Benefit	6,976.19
9
Sheet1

Hi there
Above is a simplified version of my worksheet.
Basically, we've paid expenses to employees that must be treated as taxable benefits. That is, we must calculate the amount an employee would earn in order to receive that amount and then tax them on that "gross" figure, which is there liability.
The formulas show the steps to arrive at this, but I would like an arrag formula in B* to give me the same total I have in E6. So far all my attempts have given values significantly off this number.

Any help would be greatly appreciated

 

[Andrew Poulsom]

This worked for me:

=SUM((B3:B5)*(C3:C5)/(1-(C3:C5)))

Don't forget Ctrl+Shift+Enter.

 

[Richard Schollar]

Or:

=SUMPRODUCT(B3:B5,C3:C5,1/(1-C3:C5))

which isn't an array formula, so doesn't need to be CSE entered.

Richard

 

[August]

This worked for me:

=SUM((B3:B5)*(C3:C5)/(1-(C3:C5)))

Don't forget Ctrl+Shift+Enter.

Brilliant !!! - Thank You