how can I write a formula to do this:
If A1-A10 is 0 or greater, add 1, if blank leave blank. Something like this: =IF(A1:A10>=0, "ADD 1", "LEAVE BLANK"
For example:
# A B
1 0 1
2
3 7 8
5
6
7 10 11
8
9 11 12
9
10 15 16
THANK YOU IN ADVANCE FOR YOUR HELP!
Bookmarks