Forum

Notifications
Clear all

How to use conditional functions on a negative number?

2 Posts
2 Users
0 Reactions
223 Views
(@kathcct13)
Posts: 1
New Member
Topic starter
 

If my data consists of positive and negative numbers, how would I use the IF Funtion

 
Posted : 06/05/2023 12:52 am
Riny van Eekelen
(@riny)
Posts: 1196
Member Moderator
 

In general you would do something like this:

=IF(A1>=0, "Positive", "Negative")

In words, this says: If the value in A1 is greater than or equal to zero, then return "Positive" else return "Negative". Obviously you would want Excel to perform some sort of calculation, so you would replace these words with whatever calculation need to be performed when the test is TRUE or FALSE.

 
Posted : 06/05/2023 12:58 am
Share: