Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am still struggling on how to figure out the formula for the IF in ages, and earned income and unearned income. Could you please

I am still struggling on how to figure out the formula for the IF in ages, and earned income and unearned income.

Could you please show me how this will work. I have attached the file for you thanks

Using the filing requirements for dependents table below,develop a formula that will display "Y" (Yes) or "N" (No) as a response to whether or not the user is required to file. The user is a dependent that is claimed on another's tax return, but there are circumstances when dependents must file. The template will allow the user to enterdata into the yellow areas. The formula and resulting answer should appear in the red area.

image text in transcribed Using the fling requirements for dependents table below, develop a formula that will display "Y" (Yes) or "N" (No) as a response to whether or not the user is required to fle. The user is a dependent that is claimed on another's tax return, but there are circumstances when dependents must fle. The template will allow the user to enter data into the yellow areas. The formula and resultng answer should appear in the red area. Filing Status (S= Single, MFJ = Married Filing Joint, MFS = Married Filing Separate) S S S Age Blind (Y/N) Unearned Income 17 N $5,000 Earned Income (Assume W-2 Income Only. Self Employment Income ignored) Do I have to File ? (Y/N) $2,300 N

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Accounting

Authors: Christopher D. Burnley

2nd Canadian Edition

1119406927, 978-1119406921

More Books

Students also viewed these Accounting questions