In need of support?

Support is provided on a first come, first served basis through email. Additional sources are:

  • Help and Tutorial: RulesBase includes an extensive help file and a Language Tutorial.
  • Support KnowledgeBase: the Gray Box Software website, located at www.grayboxsoftware.com maintains a knowledgebase of known issues.
  • Contact if you can not find an answer. We also welcome comments or suggestions at .

* - denotes required field

* Name:
* Phone:
* Email:
* Comments:
 

Knowledge Base

How To Replace Nested If Statements

Published October 02, 2006

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(c4<100000,.3,if(c4>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%

Return to Knowledge Base