Thanks for your response
Your solution is not exactly what I want because you need to use other cells to implement.
Imagine you want to use tables with formulas like this:
Code:
Formula X Y
40 5 8
0 2 3
63 7 9
0 1 8
80 8 10
Where the cell Formula has this: "=IF([X]*[Y]30;[X]*[Y];0)"
Is there anyway to do this "=IF([X]*[Y]30;ResultFromTheLogicalTest;0)" without creating another column only for the "[X]*[Y]" calculation or use other cells?
Maybe some hidden IF parameter that does this: "=IF([X]*[Y]30;@result;0)" or other kind of function that I don't know.
Thanks