Forum Discussion
Multiple =IF Function
Dear Community, First, I’m rather new to Excel and have no programming background. Maybe I’ve undertaken more than I can handle, but I’m a quick learner. I’ll keep this a short as p...
ProTee May I suggest that you just put the MAX() inside the IF() statement. As you noted, the MAX() is much cleaner and clearer to read than the multiple IF conditions. So
=IF( [tee to hole] = 0, "", MAX(...) )
But at this point it is mainly a readability and serviceability issue, not functional so of course use what you are most comfortable with.
Glad your issue has been worked out.
