• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell remains blank

SbusyCR

New Member
Hi,

I wonder why when the result is true on =IF(AND(F$8>=$D9, F$8<=$E9),"1",""), the cell does not display "1". I understand that the 1 is not treated as a number.
 
62536

Should you want to display the result in : "1"

Then, try this :

=IF(AND(F$8>=$D9,F$8<=$E9),"""1""","")

Regards
Bosco
 
Last edited:
Thanks Bosco! However, I would like to know the logic behind why it remains blank. Screenshot attached. Cell is filled light blue through a conditional formatting rule but the cell text color itself is not white, thus the question.
 

Attachments

  • blank.PNG
    blank.PNG
    9.8 KB · Views: 9
Last edited:
Back
Top