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 firstname.lastname@example.org I can email spreadsheet if you can help. Please contact me on my email.
I hope someone can help please.
Centrelink deductions (b18)
Salary sacrifice (h18)
Weekly, fortnightly, monthly, 90 days drop down box (i20)