use "if" and "max" in the same function

[klcorliss]

how do you use "if" and "max" in the same function

[Doug Glancy]

klcorliss,

"If Max calls, tell him I'm on my way."

or:

=IF(MAX(B1:B5)>5,"big","little")

hth,

Doug


"klcorliss" <[email protected]> wrote in message
news:[email protected]...
> how do you use "if" and "max" in the same function