Forum Discussion
IF function and Structured references need syntax help
I have spent hours trying to figure this formula out, and I am so tired and ready for this to end. I need help trying to set up syntax. To enter a formula using the IF function and structured referen...
Where did the structured references go? Why not
= IF([@tier]="platinum", [@sales]*5%, 0)But then, I am the only person on this forum that refers to the A1 notation as an abomination that has no place in any computational environment!
Come to think of it, we also advocate against hard-coding values in a formula. So why wouldn't
= IF([@tier]="platinum", [@sales]*5%, 0)become something like
= IF([@tier]="platinum", [@sales]*PctMult, 0)referring to a named range off to the side?