Forum Discussion
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,...
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))
That will work. Sometimes a different perspective is needed. This simplified what was ending up a tedious and complicated IF or IFS statement.
Thanks!
bgrace , you are welcome