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...
It would help give you a specific formula if you were to show us the actual layout of your data. Absent that, only a general idea of the IF formula can be supplied.
So, assuming "tier" is in cell C2 and "total sales" is D2, then this formula could go in E2 (or wherever you want it to be).
=IF(C2="platinum",D2*.05,0)
