If negative number then enter text

Chelsea Duncan · 09/13/21

I would like to enter text in a cell if another cell has a negative number. Can I do this or do I have to specify a range of numbers?

If "H-Days between deadline complete" is a negative number then enter "Late" into "Late" column.

Thank you,

Chelsea

Chelsea Duncan · 09/14/21

i had to use this:

=IF([H-Days between deadline complete]1 < 0, "Late")

Jason Duryea · 09/13/21

Assuming you looking for a formula, would something like this work for you?

=IF(H-Days@row < 0, “Late”, “In Progress”)

There are also new automation workflows available to Change a Cell Value based conditions.

Chelsea Duncan · 09/14/21

=IF(H-Days between deadline complete@1<0,"Late") didn't work.

I looked at automation but I don't see an option for <0

Chelsea Duncan · 09/14/21

i had to use this:

=IF([H-Days between deadline complete]1 < 0, "Late")

Best Answer