mardi 28 avril 2015

IF statement with multiple worksheets in Excel

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