Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

If positive number say yes if negative say no

I'm looking for a way that I can get the sum of 2 boxes when the formula goes through to present a yes or no in another box in the text of "Yes!" or "No!"

An example is if a1 = 4 and b1 = 5 I want c1 to run something like this:

c1 = sum(a1-b1<0 say no, a1-b1>0 say yes)
like image 733
TheTripleDeuce Avatar asked May 18 '14 11:05

TheTripleDeuce


People also ask

Is there an if negative function in Excel?

The IF function in Excel can be just as effective in making numbers negative. For example, if column A in Excel contains your list and you want column B to contain the negative values, the following IF formula can be used in column B: =IF(A2>0,A2*-1,A2).

Is zero a positive number?

Positive numbers are greater than 0 and located to the right of 0 on a number line. Negative numbers are less than 0 and located to the left of 0 on a number line. The number zero is neither positive nor negative.


Video Answer


1 Answers

Try the following:

=IF((A1-B1)<=0,"No!","Yes")
like image 169
Jacob Jan Tuinstra Avatar answered Nov 15 '22 12:11

Jacob Jan Tuinstra