I think I am asking a simple question that I should be able to find the answer too online, but 30 minutes later I still cant work it out, so sorry in advance.
I need to perform:
IF A1 is greater than 6 subtract 0.5, store this result. IF CELL A2 is greater than 6 subtract 0.5, store this result and so on x7. Calculate the sum of the total.
So i have
=IF(A1>6)-0.5
And I'm already wrong... I've no idea what I'm doing honestly and I can't find a simple source to explain it, I'm not really familiar atall with this.
Bookmarks