# Can logical function (IF) use non-numberic text?

1. ## Can logical function (IF) use non-numberic text?

Hi,

I was wondering it is a must to use numbers for IF function?

The purpose is to set up a confirmation sheet for verification purpose, in
the following way:

(1) Confirmation cell (e.g. C1): Y/N whereas Y = Yes and N = No

(2) If the C1 = Y, D1 = Unit Price x QTY

But it seems that I have to use numeric values, such as 1 or 0 for C1 and
cannot use Y/N which is more like "human language".

Or any other approach?

Many thanks

2. ## Re: Can logical function (IF) use non-numberic text?

You need to put the text in quotations, i.e.

=IF(C1="Y",Unit price x Qty,"")

--
Regards,

Peo Sjoblom

"xfile" <cou-cou@remove.nospam.com> wrote in message
news:%236FA13R1FHA.3376@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I was wondering it is a must to use numbers for IF function?
>
> The purpose is to set up a confirmation sheet for verification purpose, in
> the following way:
>
> (1) Confirmation cell (e.g. C1): Y/N whereas Y = Yes and N = No
>
> (2) If the C1 = Y, D1 = Unit Price x QTY
>
> But it seems that I have to use numeric values, such as 1 or 0 for C1 and
> cannot use Y/N which is more like "human language".
>
> Or any other approach?
>
> Many thanks
>

3. ## Re: Can logical function (IF) use non-numberic text?

Hello,

Many many thanks

It does work that way and it is NOT case-sensitive, so the user can enter Y
or y.

Once again, thanks.

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:eWw6V%23R1FHA.1132@TK2MSFTNGP10.phx.gbl...
> You need to put the text in quotations, i.e.
>
> =IF(C1="Y",Unit price x Qty,"")
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "xfile" <cou-cou@remove.nospam.com> wrote in message
> news:%236FA13R1FHA.3376@TK2MSFTNGP14.phx.gbl...
>> Hi,
>>
>> I was wondering it is a must to use numbers for IF function?
>>
>> The purpose is to set up a confirmation sheet for verification purpose,
>> in the following way:
>>
>> (1) Confirmation cell (e.g. C1): Y/N whereas Y = Yes and N = No
>>
>> (2) If the C1 = Y, D1 = Unit Price x QTY
>>
>> But it seems that I have to use numeric values, such as 1 or 0 for C1 and
>> cannot use Y/N which is more like "human language".
>>
>> Or any other approach?
>>
>> Many thanks
>>

>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1