• 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.

place tick in a cell if another cell is not empty

S

Shazz

Member
Hi All,

I would like to if and how to place a tick in cell A1 if N1 is not blank.

Is this possible.

Shazz
x
 
Could you advise me how to adapt for a range of cells, if any of the cells are not blank, I have tried the below but it's not working.

=IF(N17:R17<>"","P","")
 
Shazz said:
Could you advise me how to adapt for a range of cells, if any of the cells are not blank, I have tried the below but it's not working.

=IF(N17:R17<>"","P","")
Click to expand...

=IF(N17:R17<>"","P","")
You can do it with CSE
Write formula and press Ctrl+Shift+Enter
But this may or may not work with mix number / string.

This may work with range:
=IF(OR(COUNT(N17:R17),COUNTA(N17:R17)),"P","")

Regards,
 
=IF(OR(COUNT(N17:R17),COUNTA(N17:R17)),"P","")
Click to expand...

That worked perfectly, thanks.

Another question for you can the above be adapted so that if "No Timesheet" is entered in Cell T17 then is will leave the cell blank instead of putting a tick in it?

Shazz
x
 
Shazz said:
That worked perfectly, thanks.

Another question for you can the above be adapted so that if "No Timesheet" is entered in Cell T17 then is will leave the cell blank instead of putting a tick in it?

Shazz
x
Click to expand...


=IF(AND(COUNTBLANK(C2:C8)=0,T17>0),"P","")
 
Not quite sure were you got C2:C8 from but I have tried the below and it does not work.

=IF(AND(COUNTBLANK(N17:R17)=0,T17>0),"P","")

I do need the formula to only not tick the cell if the word "No Timesheet" appears in T17, otherwise if N17:R17 are not blank and ther is no "No Timesheet" in T17 it will then tick.

I hope I am making sense.

Shazz
x
 
What is it :No Timesheet
Is a text then
=IF(AND(COUNTBLANK(N17:R17)=0,T17<>"No Timesheet"),"P","")

I assume it as time stamp means numeric..
 
Shazz said:
Not quite sure were you got C2:C8 from but I have tried the below and it does not work.

=IF(AND(COUNTBLANK(N17:R17)=0,T17>0),"P","")

I do need the formula to only not tick the cell if the word "No Timesheet" appears in T17, otherwise if N17:R17 are not blank and ther is no "No Timesheet" in T17 it will then tick.

I hope I am making sense.

Shazz
x
Click to expand...

is this: ?
=IF(T17="No Timesheet","",IF(COUNTBLANK(N17:R17)=0,"","P"))
 
Khalid,

Your going to hate me, your formula works lovely except, when everything is blank, so no text or numbers entered I do not want a tick to show see Snap Shot below.

Blank.JPG
When there is numbers in N,O,P,Q,R but no "No Comments" in T, I need a tick in Cell A only see below snap shot.

Completed.JPG

If there is numbers in N,O,P,Q,R and "No Timesheet" stated in T I do not want a tick in Cell A, see Snap Shot below

No Timesheet.JPG

I really hope this makes sense to you as I don't want to keep wasting your valuable time.

Shazz xx
 
The 2nd and 3rd Snap shot are working fine, it is just the first 1, its shows a tick when all is blank, I do not want a tick.

Shazz
 
You must log in or register to reply here.
Back
Top