Microsoft Office Forums - View Single Post - [Solved] Excel Percentage Formula

Thread: [Solved] Excel Percentage Formula

View Single Post

Old

06-05-2018, 02:54 AM

Roger Govier Roger Govier is offline

Roger Govier is offline

Roger Govier uses Windows 10

Windows 10 Roger Govier uses Office 2016

Roger Govier uses Office 2016

Office 2016

Novice

Join Date: Oct 2017

Location: Abergavenny, Wales, UK

Posts: 13

Roger Govier is on a distinguished road

Default

I placed the following values in cells

Code:

D2 8555.5
E2 15%
D3 10000
E3 20%
D4 83333
E4 30%

Then with the Salary level in cell A2 the formula is

Code:

=SUM((A2>D4)*(A2-D4)*E4,(A2>D3)*(MAX(D4,A2-D3))*E3,(A2>D2)*(D3-D2)*E2)

Reply With Quote