Închis

Google Sheets formula assistance

Hi!

I have a requirement please based on the following website:

[login to view URL]

to have this generated in a Google Sheets file.

You will see from this spreadsheet, that you can input any one piece of data, hit calculate and the rest of the figures will be populated.

You will see it is based on the current Australian Tax Rate table:

[login to view URL]

Low | High | Rate

0 | 18,200 | 0%

18,201 | 45,000 | 19%

45,001 | 120,000 | 32.5%

120,001 | 180,000 | 37%

180,001+ | 45%

So, I would need the same ability in a Google Sheet, to:

* Enter any data point as per the link above

* And have the data populate

* With the option to ‘clear’ all data and start again

The website : [login to view URL] is great but slightly incorrect with it’s calculation, but the following Google Sheets calculator is correct:

[login to view URL]

As you will see, based on an income of $80,000 entered in D4, the result in D13 : $17,547.00 is the tax result I would need in the spreadsheet (based on the official tax rates table / link provided above.

I have tinkered with the Goal Seek feature in Google Sheets, but (I think) I would need to call the goal seek function via script which I don’t have the advanced knowledge for (or a Macro?)

Further to this, I have put together the following explanatory video for your review:

[login to view URL]

(you might need to download to view in HD)

Here are the websites referenced:

[login to view URL]

[login to view URL]

[login to view URL]

FYI - one of our older suppliers worked on this previously, but is unfortunately now away until the end of the month (and we need it done this week) - he put together the following video showing how he had it complete the requirements, just with formulas, no script:

reverse tax calculator explanation video : [login to view URL]

(you might need to download the video to view in HD)

Can you please review and advise if you can do the same?

The price of his supply (and therefore our budget) is USD$100.

Please review and let me know, thanks in advance!

Aptitudini: Google Sheets

Vezi mai multe: google sheets formula, advanced google sheets, google sheets autofill formula, things we think we need but don't, google sheets filter custom formula, google sheets advanced tutorial, google sheets find and replace formula, google sheets hyperlink formula, google sheets timesheet formula, google sheets array formula examples, google sheets array formula vlookup, google sheets array formula filter, google sheets array formula if, google sheets array formula, google sheets conditional formatting custom formula multiple conditions, google sheets timestamp formula, google sheets formula builder, convert google sheets formula to excel, how to lock a cell value in google sheets formula, google sheets formula parse error

Despre angajator:
( 0 recenzii ) Scarborough, Australia

ID Proiect: #29440123

3 freelanceri licitează în medie 152$ pentru acest proiect

writingapp

Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 3 days

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% AUD în 3 zile
(10 recenzii)
3.8
(10 recenzii)
3.4
(0 recenzii)
0.0