want to write if staement giving the tax for 2017 and 2018. so the users that ty

Question

want to write if staement giving the tax for 2017 and 2018. so the users that typy a different year sould display they are putting different year . in other word we work for the tax in 2017 and 2018. Also if the user put negative number should display that nagtive number not allowed

here is some example for the program:

please use if statement ..thank you

2017 Tax Table 2017 Rate 10% 15% Taxable Income Bracket $0 and s$9325 >-s9325 and 38,700 ande-S82.5 >$82,500 and cS1 57,500 .>$157,500 and $200,000 and

Explanation / Answer

Slight modification on the above;

Less than or equal to 600 widgets you get 0 wingdings
= to and above 651 you get 30 wingdings
than for every additional 50 widgets you get 2 wingdings
eg 651 widgets get 30 wingdings
704 widgets get 32 wingdings
810 widget get 36 windings

Thanks

Reply

Philip Treacy says

August 21, 2018 at 4:27 pm

Hi Andrew,

You don’t say what to do if the number is between 600 and 651?

Otherwise, you can use this

=IF(A1>=651,30+(INT((A1-650)/50)*2),0)

Regards

Phil

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.