Notifications
Clear all
Advanced Excel Formulas
2
Posts
2
Users
0
Reactions
223
Views
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
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