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

14 thoughts on “excel dummy

  1. plenty of fish dating site

    Thanks for your personal marvelous posting! I seriously enjoyed reading it, you happen to be a great author.I will remember to bookmark your blog and will eventually come back later
    on. I want to encourage you to continue your great writing, have a nice morning!

  2. quest bars cheap

    You can definitely see your expertise within the work you write.
    The arena hopes for even more passionate writers like you who are not
    afraid to mention how they believe. All the time follow your heart.

  3. ps4 games

    I like the valuable information you provide in your articles.
    I will bookmark your weblog and check again here frequently.
    I’m quite certain I’ll learn a lot of new stuff right here!
    Good luck for the next!

  4. ps4 games

    Thank you for every other wonderful post. The place
    else may anyone get that kind of info in such a perfect manner of writing?

    I’ve a presentation next week, and I’m at the look for such information.

  5. ps4 games

    I seriously love your website.. Excellent colors & theme.

    Did you create this site yourself? Please reply back as I’m
    attempting to create my own personal website and
    would love to find out where you got this from or what the theme is named.
    Appreciate it!

  6. Mike Canty

    This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want?HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

  7. ps4 games

    Attractive element of content. I simply stumbled upon your website
    and in accession capital to assert that I get actually loved account
    your blog posts. Anyway I will be subscribing to your augment or even I fulfillment you access constantly
    rapidly.

  8. sling tv

    We’re a group of volunteers and starting a new scheme in our
    community. Your web site offered us with valuable information to work on. You’ve
    done an impressive job and our entire community will be grateful to you.

  9. sling tv

    I’m not sure where you’re getting your information, however good topic.
    I needs to spend some time finding out much more or understanding more.
    Thanks for fantastic info I was looking for this info for my mission.

  10. sling tv best package 2020

    Good day I am so happy I found your website, I really found
    you by error, while I was searching on Digg for something else, Regardless I
    am here now and would just like to say cheers for a
    remarkable post and a all round exciting blog (I also love the theme/design), I don’t have time to go through it all at the minute but I have saved it and also added your RSS feeds, so when I
    have time I will be back to read much more, Please do keep up
    the excellent work.

Leave a Reply

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