Hi all,
I need to subtract some values form a base value only if another cell is filled. Because this has to be done for multiple cells, I now have the working forumla
=H3-IF(ISBLANK(A3);0;E3)-IF(ISBLANK(A4);0;E4)-IF(ISBLANK(A5);0;E5)-IF(ISBLANK(A6);0;E6) continued to cell 13.
This is not a good looking formula, and I have the feeling it should be possible to make it (a lot) shorter, but I can't figure it out. I've tried it in an array formula as
=H3-IF((ISBLANK(A3:A16));0;E3:E16)
But this only appears to work for the cells in row 3.
I was wondering if anyone knows a way to make this formula more efficient. Thanks in advance.
Cheers, Bart
I need to subtract some values form a base value only if another cell is filled. Because this has to be done for multiple cells, I now have the working forumla
=H3-IF(ISBLANK(A3);0;E3)-IF(ISBLANK(A4);0;E4)-IF(ISBLANK(A5);0;E5)-IF(ISBLANK(A6);0;E6) continued to cell 13.
This is not a good looking formula, and I have the feeling it should be possible to make it (a lot) shorter, but I can't figure it out. I've tried it in an array formula as
=H3-IF((ISBLANK(A3:A16));0;E3:E16)
But this only appears to work for the cells in row 3.
I was wondering if anyone knows a way to make this formula more efficient. Thanks in advance.
Cheers, Bart