Thread: use "if" and "max" in the same function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Glancy
 
Posts: n/a
Default use "if" and "max" in the same function
klcorliss,

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

or:

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

hth,

Doug


"klcorliss" wrote in message
...
how do you use "if" and "max" in the same function


Reply With QuoteReply With Quote