IF Function in Excel

vbimport

#1

Hello, does anybody know if it is possible to have a cell as the true/false value?

I keep getting errors with this consequential formula:
=IF(K18 < B18, B18, K18)

What I need Excel to do is use the largest value of the cells B18 and K18.

I have been searching the web but can’t seem to find the proper formula, so it occurred to me that maybe cells can’t be true/false values…

Hope somebody knows so I can quit my queste and get on with it :confused:


#2

Hi,[quote=6k;2181116]I keep getting errors with this consequential formula:
=IF(K18 < B18, B18, K18)[/quote]
=if(K18<B18;B18;K18)

What I need Excel to do is use the largest value of the cells B18 and K18.

=max(B18;K18)
should do.

Excel has a really good help built-in :wink:

Michael


#3

Yes, this works! Thank you so much!! :slight_smile:


#4

you’re welcome :slight_smile:


#5

Thanks for the good information.