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)
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).
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.
Try the following:
=IF((A1-B1)<=0,"No!","Yes")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With