B
bmistry
Hi,
I am trying to insert this formula.
(IF(ISBLANK(G9),(F9+M9+L9+K9)/4,IF(ISBLANK(H9),
(G9+F9+M9=L9)/4,IF(ISBLANK(I9),(H9+G9+F9+M9)/4,IF(ISNUMBER
(I9),(I9+H9+G9+F9)/4)))))
However, the cells that I am basing this formula on
(ie.G9, H9) have formula's in them, so the result of the
above formula comes out FALSE.
Is there anyway I can use the ISBLANK or something similar
to do this?
Thanks in advance
bmistry
I am trying to insert this formula.
(IF(ISBLANK(G9),(F9+M9+L9+K9)/4,IF(ISBLANK(H9),
(G9+F9+M9=L9)/4,IF(ISBLANK(I9),(H9+G9+F9+M9)/4,IF(ISNUMBER
(I9),(I9+H9+G9+F9)/4)))))
However, the cells that I am basing this formula on
(ie.G9, H9) have formula's in them, so the result of the
above formula comes out FALSE.
Is there anyway I can use the ISBLANK or something similar
to do this?
Thanks in advance
bmistry