excel dummy

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

Need to email excel spreadsheet to you as it may be easier to understand.

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

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

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

###Both of the above “if’s” have to apply to total income based on whether the income is weekly, fortnightly, monthly or 90 days.

My email is gavin.roymcleod@gmail.com 

I hope someone can help please.

Centrelink (b17)

Centrelink deductions (b18)

Wages (h17)

Salary sacrafice (h18)

Other (h19)

Capacity (i62)

By: Gavin Mcleod

Leave a Reply

Your email address will not be published. Required fields are marked *