add if populated with some text

  • Thread starter Thread starter MrJim005
  • Start date Start date
M

MrJim005

Hi all



In cell B13 I need it to add 1 to B12 only if C13 is populated with some
text or a number. Can this be done? Thank You
 
I think this is what you mean:

=IF(TRIM(C13)="some_text",B12+1,0)

in B13. You didn't specify what you wanted if C13 does not contain the
required text, so I've assumed you want 0, although you might want to
change this to B12.

Hope this helps.

Pete
 
B13 should be blank if nothing is entered in C13, C13 will be a variety of
words from a drop down list on another sheet.
 
Is this what you are looking for?

=IF(TRIM(C13)="","",1+B12)

Or do you want this **only** if C13 contains some specific text strings?

Rick
 
Back
Top