JustOneQuestion
New Member
- Joined
- Jul 5, 2016
- Messages
- 19
I am trying to get excel to show what is left over 40. Is it possible? I do not want any negative numbers either. Here is an example:
<colgroup><col><col></colgroup><tbody>
</tbody>All I did was subtract 40 from column A. But I do not want the values in B if it is negative. If the value in A isn't over 40, I do not want anything in column B. I tried a countif formula, but that will either take the whole number, or only a 1. Neither of which helps me.
Any thoughts?
Thanks!
45.25 | 5.25 |
59.25 | 19.25 |
43.25 | 3.25 |
29.75 | -10.25 |
30.5 | -9.5 |
21 | -19 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Any thoughts?
Thanks!