Isblank

[dada_man]

I'm try to use ISBLANK to look at a string of cells and if they are blank to leave the target cell blank.
Has anyone tried this or have a similar solution using a different function?
IE
=IF(ISBLANK(G7:H7)=FALSE,SUM(I6-H7+G7),"") is on cell I7.
Make - I6 - $700
if you leave H7 and G7 blank, I7 should be blank- it's not-it's $700.

[tuph]

ISBLANK works okay for me. Can you give us a bit more detail about the problem?

[Ikaabod]

How about:
=IF(G7&H7<>"",SUM(I6-H7+G7),"")

[daddylonglegs]

Because you're looking at a range of cells with ISBLANK your formula actually needs to be array-entered, i.e. confirmed with CTRL+SHIFT+ENTER, I'd go with Ikabod's suggestion, although it normally doesn't make sense to use both SUM and + and - so you should probably use just

=IF(G7&H7<>"",I6-H7+G7,"")

[dada_man]

Thanks guys that is way better solution.
You guys really know what you are doing.

Thanks