Array Help Please!!

August

Active Member
Joined
Jun 18, 2004
Messages
264
Book1
ABCDE
1Tax Liability
2NameExpensesTax RateBenefitTax
3J Smith1,500.0030%2,142.86642.86
4P Jones12,000.0020%15,000.003,000.00
5A Boot5,000.0040%8,333.333,333.33
618,500.0025,476.196,976.19
7
8Taxable Benefit6,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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Or:

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

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

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top