Web Form Formulas Challenge
We are looking for the syntax for a web form formula of an if-statement that would allow to have a row calculate different formulae depending on the column it comes across.
In the style of the below, but instead in the IF argument an statement that checks in which column we are:
IF( [3]<>0 , EVAL( ROUND( EVAL([A,3]-[B,5]),0) ) , EVAL(ROUND( EVAL([A,3]+[B,3]-[C,3]),0) ) )
We are assuming/experiencing following limitations/possibilities (if anyone can contradict, please reply that too!):
- Formulas are only possible on total rows or total columns, not in cells. As opposed to Cell validation, that can be cell specific :-(