CODEWITHSUNDEEP
excel
Swazzy
Swazzy

Reputation: 97

Return text within the same cell if value is less than zero

Is it possible to return a text value within the same cell if a cells formula result is less than zero..

I have a formula =A2+B2, if the result is positive then display result , if negative then "No Bonus" ..

Upvotes: 2

Views: 19508

Answers (1)

BruceWayne
BruceWayne

Reputation: 23283

Yes, just use an If() formula.

Say the cell with the formula =A2+B2 is C1, you can do this:

=If(C1>=0,C1,"No Bonus")

Or without the C1 cell: =If((A2+B2)>=0,A2+B2,"No Bonus")

Note that if the employee gets 0, that's included as a "positive".

Upvotes: 2

Related Questions