Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Hi @Macca ,
Is this calculation to be made on power query or power pivot? or a simple excel spreadsheet?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |