Cell to show blank

[mrcois]

I have given an explanation on the attached sheet.

What I basically want to do is for the formula to look at two different cells and when both have no data in, give a blank UNTIL both have data in again.

[teylyn]

try

=IF(OR(A8="",C8=""),"",SUM(A8/C8))

Then again, you don't need the "SUM" around the division. SUM() does not add anything to the formula, just uses computing power.

=IF(OR(A8="",C8=""),"",A8/C8)

is more efficient and less typing.

cheers

[mrcois]

Thanks, that worked 100%...

[mrcois]

I have uploaded another example. If you can help me, I'll will appreciate it...

[Dulanic]

This will work:

=IF(AND(B8="",A8="",A3="",B3=""),NA(),SUM(A3:B3,A8:B8))

Tho what you asked for in the workbook isn't exactly what your title asks for since you said cell to show blank....

[mrcois]

Yes sorry, I did use the blank option previously in this thread.

Thanks for the formula hey, it works 100%...

[teylyn]

Dulanic's formula could be shortened to

=IF(count(B8,A8,A3,B3)<4,NA(),SUM(A3:B3,A8:B8))