excel help

[Guest]

I'm trying to generate a value equal to that of the greater value of 2
compare cells, any way to do this with an If statement. I have only been able
to generate "true" or False values.

 

[Don Guillett]

have a look in the help index for MAX or CEILING

 

[Guest]

Assuming the values are numeric:

myVal = Application.Max(range("A1"),range("B9"))