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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use "if" and "max" in the same function (https://www.excelbanter.com/excel-worksheet-functions/82300-use-if-max-same-function.html)

klcorliss

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

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

Doug Glancy

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

All times are GMT +1. The time now is 03:19 AM.