This is my formula. =IF(Start!I7:End!I7>0, 0, Start!I7:End!I7) I get the error #value!
I have a worksheet called Start at the beginning and a worksheet called End at the end of the sheets.
On my sheet in the middle, I want a cell to add up all of the I7 values from Start to End and if it is greater than 0 to display 0. If not, I want it to display the sum of all of the I7 values.
This formula works if I do =IF(Start!I7-End!I7>0, 0, Start!I7-End!I7) with the subtraction.
Aucun commentaire:
Enregistrer un commentaire