Hi All,
I have a very simple formula which is basically one cell minus another "=A1-B1".
When the values are equal, the cell this formula is in will display a zero. However, when the subtracted figure is greater than the first figure, i will then get a minus figure E.g. 10-11 = -1.
How can i make it that when the formula result is less than zero (i.e. a minus number) the figure displayed stays at zero but still using the minus funciton?
Basically once it hits zero i need it to stop subtracting.
This may be really simple but i cant figure it out.
Thanks
Bookmarks