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.

have a look in the help index for MAX or CEILING

--
Don Guillett
SalesAid Software

"msubks" wrote in message
...
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.

Assuming the values are numeric:

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

--
Regards,
Tom Ogilvy


"msubks" wrote:

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.