Good evening,
I hope someone can help me with my Excel problem...
I have 25 cells, that can either have a value of 0 or o.2
The cells have to be added up. No problem there ofcourse.
But if a cell has a value of 0, -0.25 should be subtracted from the total.
I have this formula, but I'm not sure how to use it for multiple cells:
=IF(M20,0,-0.25)
Does anyone have a clue?
Thanks,
Car
Bookmarks