How To Eliminate Nested If Statements

RulesBase is designed to be easy to read. Therefore, Nested “If” statements should be avoided. In Microsoft Excel, a nested if statement might read “=if(c42<100000,.30,if(c42>200000,.39,.34))”

RulesBase will allow multiple Rules to solve one variable:

if Net Revenue < 100000 then Tax Rate = 30%
if Net Revenue between 100000 and 200000 then Tax Rate = 34%
if Net Revenue > 200000 then Tax Rate = 39%