#value! Return

[mick2]

Hi,

The first ISBLANK in the following formula, doesn't work (while everything else, does).

=IF(ISBLANK(D7)," ",)+IF(ISBLANK(G7),(I6+E7))+IF(G7>0,(F7-H7))

Each time that D7 (a data, input cell) is indeed blank, I get the ubiquitous, #VALUE! return.

How can I suppress, the #VALUE! return?

Cheers,
Mick2.

[Mallycat]

There is a problem with your formula and you are adding blank spaces to numbers

so the first part of your forumula
=IF(ISBLANK(D7)," ",)
will return " "

And then you add this " " to the answer of the following.

+IF(ISBLANK(G7),(I6+E7))+IF(G7>0,(F7-H7))

Try putting the last bracket of your first IF statement at the end of the formula

=IF(ISBLANK(D7)," ",IF(ISBLANK(G7),(I6+E7))+IF(G7>0,(F7-H7)))

Matt

[mick2]

Hi Matt,

Your suggestion fixed the problem.

"Thanks a million!"

Cheers,
Mick2