One way:

=IF((A1+B1)<0, "yes", "no")

which assumes that a zero value should be "no".

There's no special language you should learn for using XL itself. Use
Help liberally instead.

If you want to learn to use macros, they're written in Visual Basic for
Applications (VBA). But that generally won't help you with worksheet
functions.

In article ,
"NeedtoExcel" wrote:

I need a cell to display "yes" if the total of two cells is negative and no
if posititive.

Also, is there a computer language that I should learn that would help me
figure out these type of issues in the future?