Hello.

I'm working on an excel spreadsheet which selects the highest value from a list of values and outputs how much a particular number (x) has to increase by to surpass that value.

So far I've managed to create a macro that does exactly that, but it becomes a negative number if (x) is already greater than the highest value in the list. I would rather the output cell change to something along the lines of "Congratulations!" if the number needed to exceed the highest value in the list is less than or equal to zero. Is there any way I can do this?

The macros I have so far are:
J2=SUM(MAX(G11:G21)) - G10
and
I21=IF(J2 <> 0, "Congratulations!", J2)

Thanks in advance.