Shows empty cell instead of FALSE

Maybe this problem has been exposed here and I found different solutions but fail to adapt to my problem.
I have this formula

Formula:

Please Login or Register  to view this content.

which works fine if the cell ('OVERALL'! F4 <> "") have really something (normally has an "a" or nothing).
But if there is nothing in, the result is FALSE.
What should I change in the formula for leaving an empty cell.

Thanks in advance.

try NOT(ISBLANK('OVERALL'!F4)) instead of 'OVERALL'! F4 <> ""

Hi Anka,

I'm not sure exactly what your formula is doing, but looking at your original formula, the 2nd section referenced if G4 was blank, not F4 again...

It's something like: 2 RESULTS IN 1 FORMULA .

Check Marck in G4 (have something) - see the first result.
Check Marck in F4 ((have somthing)- See the second result.

If G4 and F4 have nothing - the result is FALSE. And I want an empty cell.

Hi Anka,

Try this...

Please Login or Register  to view this content.

Quick lesson of using F9... if you highlight 'OVERALL'!F4 inside the formula and press F9, you will get a calculated value (0 or 'a')... you can expand the highlight to 'OVERALL'!F4<>0 and get TRUE or FALSE... so use F9 within a formala to see what you are dealing with...

Hope this helps and let me know if the formula still doesn't work above...

Hi djapigo.

OK. I used F9 Quick lesson. Nice trick. The results are exactly as you say.
But remains #VALUE ERROR.

I have to go to bed (2:00 am now in PT). Tomorrow is a working day for me.
If you have some time, please see this post. There I have a sheet and maybe you understand exactly what I want to do, modifying the formulas in.
My English is not very good, and knowledge in excel are poor, failing in this way to express what I want to do.

Anyway, thank you very much for your time and attention spent on my problem.

I've attached your spreadsheet with a working formula... you were simply missing the "false" section at the end...

Let me know if this is fixes your other problem too...

Glad the little F9 trick works, keep using it to help you solve complicated formulas... we're here to help... believe it or not, it's fun and challenging... and hopefully you can contribute later too...

Originally Posted by djapigo

... you were simply missing the "false" section at the end...

Let me know if this is fixes your other problem too...

Hi djapigo.
Honestly .. I didn't know.
Yes, that's it. It works great and fix all my problems.
Maybe in the future, I hope to be helpful to someone here. But for now, I play in the beginners team.
Thanks for your patience.