cooper collier 1/19/2016 3:53:27 PM
You can nest if and case commands. Just use code formating to make it easier
//this is the true section
if ([model]="ford", red, blue"
/ /this is the false
if([model]="chevy", green, blue)
I do not see any reason to not next case commands
or nest case and if..
you just have to pay careful attention to formatting, but you can use comments and indents and returns for that.
NOTE: if you copy a formula from the page where you display all the columns then copy it to a new formula column, it tends to mess it up, when copying formula, I do it from edit to edit screens.