Thread
:
Creating a function that makes a negative number a zero
View Single Post
#
2
hodeware
Posts: n/a
Try this
=IF(A1-A2<0,0,A1-A2)
with A1 & A2 being any cells
"Tina" wrote:
I am trying to create a function that will subtract, but if the answer is
less than zero, will put a zero in the cell. I don't know how to do this.
Can you help me?
Reply With Quote