ISBLANK

[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

 

[Frank Kabel]

Hi
untested but try
=IF(G9="",AVERAGE(F9,K9:M9),IF(H9="",AVERAGE(F9:G9,L9:M9),IF(I9="",AVER
AGE(F9:H9,M9),IF(ISNUMBER
(I9),AVERAGE(F9:I9)))))

 

[Dave R.]

There are formulas in them that result in ""?

try something like

=IF(G9="",(f9+m9+l9+k9)/4, IF(h9="",

etc..

 

[Harlan Grove]

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)))))

Typo in 'IF(ISBLANK(H9),(G9+F9+M9=L9)/4,...'? Should that be
'IF(ISBLANK(H9),(G9+F9+M9+L9)/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.

...

Rewriting and condensing your formula,

IF(ISBLANK(G9),(F9,K9:M9)/4,
IF(ISBLANK(H9),(F9:G9,L9:M9)/4,
IF(ISBLANK(I9),(F9:H9,M9)/4,
IF(ISNUMBER(I9),(F9:I9)/4)))))

Only if I9 were either text or error would your formula evaluate FALSE. I'd
guess you could use the following instead.

=(F9+IF(ISNUMBER(G9),G9,K9)+IF(ISNUMBER(H9),H9,L9)
+IF(ISNUMBER(I9),I9,M9))/4