• 461K Members
• 6,908 Online
• 559K Conversations

Highlighted
New Contributor

# IFS

Hello,

I'm trying to create an equation that will calculate payroll taxes for scenario estimates on a Pro Forma.

I thought that I would use and IFS equation, but am not having any luck.

Basically, the equation needs to compute the taxes based on the amount of income.

From \$0 to \$132,900 the tax rate will be 15.3%, from greater than \$132,900 up to and including \$200,000 those earnings would be taxed at 9.1%, with any earnings over \$200,000 taxed at 10.0% and then any or all of those taxes would be summed and show as a total in the cell.

Is this something that the IFS can do? Or am I better off trying this with nesting?

Thanks in advance for any help!

3 Replies

# Re: IFS

If create such helper table

where on each next step % difference compare to previous step, formula could be

``=SUMPRODUCT((\$D\$2-\$A\$2:\$A\$5)*\$B\$2:\$B\$5*(\$D\$2-\$A\$2:\$A\$5>0))``

# Re: IFS

That will work. Sometimes a different perspective is needed. This simplified what was ending up a tedious and complicated IF or IFS statement.

Thanks!

# Re: IFS

@bgrace , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies