Find Jobs
Hire Freelancers

I need an Excel Expert

$30-250 USD

完了済み
投稿日: 6年近く前

$30-250 USD

完了時にお支払い
On the Properties worksheet, in cell J2, use the CONCATENATE function to display the city in cell C2, followed by a comma and space, followed by the state in cell D2. Fill the formula down through cell L38. AutoFit column J. On the Properties worksheet, copy the range J2:J15. Display the Region 1 worksheet and paste the values in cell D3 using Paste Values. On the Region 1 worksheet, in cell F3, use the VLOOKUP function to determine the 2017 Tax Assessment for the first property in the table. Use the 2017 value as the lookup value, the data in C19:D24 as the table array, and retrieve the tax rate for the appropriate value. Multiply the result by the 2017 value to determine the tax assessment. Fill the formula down through F16. In cell H3, use the VLOOKUP function to determine the 2018 Tax Assessment for the first property in the table. Use the 2018 value as the lookup value, the data in C19:D24 as the table array, and retrieve the tax rate for the appropriate value. Multiply the result by the 2018 value to determine the tax assessment. Fill the formula down through H16. In cell L3, insert an AND function that checks to see if both 2017 and 2018 Tax Assessments were higher than 10000. AutoFill the formula down through cell L16. In cell B17, insert the COUNTA function to count the number of cell with values in the range B3:B16. Insert a COUNTIF function in cell L17 to count the number of properties for which the High Tax value is TRUE. Insert the FV function in cell K3. Enter .015 as the rate, 12*0.5 as the number of payments, 0 as the payment, and the 2018 Tax Assessment as the present value. Edit the formula and type a minus (-) sign between (=) and FV. Fill the formula down through K16. Select cell I3. Insert an Array formula that will add the range F3:F16 and H3:H16. Fill the formulas down to cell I16. AutoFit column I. Apply the Accounting number format to the cell F3 and range H3:J3. Use the SUM function to insert an Array formula in cell J20 to add the Tax Difference values. Insert an AVERAGEIFS function in cell J23. Use I3:I16 as Average range. Return the average of taxes collected for properties where the tax collected was greater than or equal to 30000 and the High Tax value is TRUE.
プロジェクト ID: 16747803

プロジェクトについて

7個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hello I am here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill and experience in Ms excel and finance Can assist you with high regards. My below hourlie is made for you and will be cost effective as well [login to view URL] Plz share more info to proceed in project. And we can discuss more details in chat Thanks in anticipation Looking forward for this projext positively
$61 USD 3日以内
5.0 (22 レビュー)
4.2
4.2
この仕事に7人のフリーランサーが、平均$67 USDで入札しています
ユーザーアバター
Hi, I am good at Excel and formulas. Please share the file. I can review and work on the project. I will provide quick turnaround. -Chandra
$35 USD 0日以内
5.0 (782 レビュー)
7.8
7.8
ユーザーアバター
Hi, Please share the file. I have worked on various assignment projects in excel and vba. I will provide quick turnaround. -Sri
$30 USD 0日以内
5.0 (62 レビュー)
5.5
5.5
ユーザーアバター
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can help you with Excel formulas you are requiring. Please contact me by chat and then we could discuss better your project! Kind regards, Luis Romero
$35 USD 2日以内
5.0 (102 レビュー)
5.3
5.3
ユーザーアバター
Hi, I'm an advanced excel expert. Please discuss in detail over chat now. Thank you!.........................................................................................
$150 USD 1日以内
4.8 (24 レビュー)
4.5
4.5
ユーザーアバター
I can do your task. I am expert in Excel spreadsheet and have done these types project as class assignments.
$111 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
A proposal has not yet been provided
$45 USD 3日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Saint Peters, United States
5.0
3
お支払い方法確認済み
メンバー登録日:4月 20, 2018

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。