add if populated with some text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MrJim005 - 14 Jul 2007 22:52 GMT

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

Reply to this Message

Pete_UK - 14 Jul 2007 22:56 GMT

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

On Jul 14, 10:52 pm, "MrJim005" <jimbea...@nospam.sbcglobal.net>
wrote:

> 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

Reply to this Message

MrJim005 - 15 Jul 2007 00:39 GMT

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.

>I think this is what you mean:
>
[quoted text clipped - 14 lines]
>> 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

Reply to this Message

Rick Rothstein (MVP - VB) - 15 Jul 2007 01:37 GMT

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

> 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.
[quoted text clipped - 17 lines]
>>> 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

Reply to this Message

MrJim005 - 15 Jul 2007 02:06 GMT

That's it! tried it and it works perfect. Folks are always awesome here.
Thank You!

> Is this what you are looking for?
>
[quoted text clipped - 26 lines]
>>>> some
>>>> text or a number. Can this be done? Thank You

Reply to this Message