"ISBLANK" forumula

Hi there.

Struggling away here trying to have the following work out:

IN the attached, I want cell "J5" to populate ONLY when there is something appearing in cell "I5". Unfortunately, that's not happening. Something appears in C5 or D5, and I get a result in the "J5".

Same issue for cell "F5".... I only want a result if something is introduced into cell E5, but not before.

(See Row 6 for a typical result as regards my problem).

Anyone's help in this matter would be greatly appreciated.

Thanks!

Somebodyhadto

Originally Posted by oldchippy

Hi,

In E5

=IF(D5="","",SUM(C5*D5)) and in J5

=IF(I5="","",SUM(I5*D5)-(C5*D5))

------------------------------

Whenever I input any figure into cells C5 or D5, cells G5 and J5 return results.

I want them to stay blank (not return any result) until I've manually typed a figure into cell F5 (respective of cell G5) and into cell I5 (respective of cell J5).

(But your formula is much cleaner than mine re the advice you have thus far provided - thanks.)

Somebodyhadto