help with excel formulas

[Macca]

Looking for help please to produce an excel formula for a finance assessment spreadsheet.

Based on income calculations I need to formulated capacity but it is based on the below:

##If (centrelink income(b17) + centrelink deductions(b18) are higher than the combined total of (wages(h17) + salary sacrifice(h18) + other(h19)) then capacity is 20% of centrelink + centrelink deductions + wages + salary sacrifice + other. 

##If (wages + salary sacrifice + other) are higher than the combined total of (centrelink income + centrelink deductions) then capacity is 40% of centrelink + centrelink deductions + wages + salary sacrifice + other. 

###Both of the above "if's" have to apply to total income (e20) based on whether the income is weekly, fortnightly, monthly or 90 days at (i20).

My email is gavin.roymcleod@gmail.com I can email spreadsheet if you can help. Please contact me on my email.

I hope someone can help please.

Centrelink (b17)

Centrelink deductions (b18)

Wages (h17)

Salary sacrifice (h18)

Other (h19)

Capacity (i62)

Weekly, fortnightly, monthly, 90 days drop down box (i20)

[MFelix]

Hi @Macca ,

Is this calculation to be made on power query or power pivot? or a simple excel spreadsheet?

Regards,

MFelix