Use of wildcards in formulae

HI

I need a little advice.

I'm trying to say that if C6 starts with the letter 'C' , then put 'Yes' 
, if not put 'No'

I'm using this formula :

=IF(C6="C*","Yes","No")

but it's not giving the correct responses. Can someone advise?

Thanks
0
Colin
2/8/2010 1:01:11 AM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
588 Views

Similar Articles

[PageSpeed] 59

Hi Colin
Try this =IF(COUNTIF(C6,"C*")>0,"Yes","No")
HTH
John
"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message 
news:tVEQEIAXJ2bLFwKd@chayes.demon.co.uk...
>
> HI
>
> I need a little advice.
>
> I'm trying to say that if C6 starts with the letter 'C' , then put 'Yes' , if 
> not put 'No'
>
> I'm using this formula :
>
> =IF(C6="C*","Yes","No")
>
> but it's not giving the correct responses. Can someone advise?
>
> Thanks 

0
John
2/8/2010 1:26:10 AM
In article <OqOfS3FqKHA.2076@TK2MSFTNGP05.phx.gbl>, John 
<johnd@newlook.com> writes
>Hi Colin
>Try this =IF(COUNTIF(C6,"C*")>0,"Yes","No")
>HTH
>John

Hi John

Yes , that's fixed it.

Thanks for your help. Much appreciated.


Best Wishes


>"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message
>news:tVEQEIAXJ2bLFwKd@chayes.demon.co.uk...
>>
>> HI
>>
>> I need a little advice.
>>
>> I'm trying to say that if C6 starts with the letter 'C' , then put 'Yes' , if
>> not put 'No'
>>
>> I'm using this formula :
>>
>> =IF(C6="C*","Yes","No")
>>
>> but it's not giving the correct responses. Can someone advise?
>>
>> Thanks
>

0
Colin
2/8/2010 3:42:46 AM
=IF(LEFT(C6)="C","Yes","No")
--
David Biddulph


Colin Hayes wrote:
> HI
>
> I need a little advice.
>
> I'm trying to say that if C6 starts with the letter 'C' , then put
> 'Yes' , if not put 'No'
>
> I'm using this formula :
>
> =IF(C6="C*","Yes","No")
>
> but it's not giving the correct responses. Can someone advise?
>
> Thanks


0
David
2/8/2010 4:23:14 AM
You're welcome .
Regards
John
"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message 
news:ELc6DKA2g4bLFwO7@chayes.demon.co.uk...
> In article <OqOfS3FqKHA.2076@TK2MSFTNGP05.phx.gbl>, John <johnd@newlook.com> 
> writes
>>Hi Colin
>>Try this =IF(COUNTIF(C6,"C*")>0,"Yes","No")
>>HTH
>>John
>
> Hi John
>
> Yes , that's fixed it.
>
> Thanks for your help. Much appreciated.
>
>
> Best Wishes
>
>
>>"Colin Hayes" <Colin@chayes.demon.co.uk> wrote in message
>>news:tVEQEIAXJ2bLFwKd@chayes.demon.co.uk...
>>>
>>> HI
>>>
>>> I need a little advice.
>>>
>>> I'm trying to say that if C6 starts with the letter 'C' , then put 'Yes' , 
>>> if
>>> not put 'No'
>>>
>>> I'm using this formula :
>>>
>>> =IF(C6="C*","Yes","No")
>>>
>>> but it's not giving the correct responses. Can someone advise?
>>>
>>> Thanks
>>
> 

0
John
2/8/2010 12:43:59 PM
Reply:

Similar Artilces:

Clear Contents But Not Formula
I want to use a complicated worksheet that was devised for last year but contents will now change to this year. How can I clear the contents of the cells, the numbers, but leave the formula remaining? Hi click in the sheet you want to do this in (please try on a copy of your workbook first), choose edit / goto, click the special button and then check "constants" .. there's some tick boxes you can play with too ... then click OK and press the delete key. Hope this helps Cheers JulieD "Gancom3" <Gancom3@discussions.microsoft.com> wrote in message news:8749...

How do you add text after a formula?
I'm working on creating a report. At the top of each section is a mont that I type in. At the bottom I want a cell to display that month an also add the word "Total". So for example I have May listed in Cell B3 I now want "May Total" to be listed in cell B36. I know if I want it t display just "May" I'd enter =B3 but how do I make it add the Tota part? Thanks in advance for any help -- Wease ----------------------------------------------------------------------- Weasel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2720 Vie...

Dates in Formulae
Dear all, Suppose I want to create a basic formula eg one which adds 6 months to a date, how would I do it? Doing it by date + 6 months worth of days will obviously not work as the number of days in 6 months will vary. Any thoughts? Thanks, Danny Hi Danny, =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) But do think about what you want the day to be in case the source date is, for example, august 31. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Aardvark" <djurmann@hotmail.com> wrote in message news:%23cU8IWF0DHA.2580@TK2MSFTNGP09.phx.gbl... > Dear all, > > ...

Formulas for race game (position calculation after each round)
Hi. I have a worksheet like the following: Player's Name-----Round1(R1)-----R2-----R3...-----Total Score====Position after R1-----Pos.(R2)-----Pos.(R3)... Position is calculated based on the score accumalted (the more scores, the better) so far. Eg: Postion after R1 depends on score got in R1. Position after R2 depends on score got in R1 & R2. Position after R3 depends on score got in R1 & R2 & R3. Q: What formulas should I use to calculate the positions up to different rounds? I think I can use RANK functions, but it seems I need to set SUM formulas to calculate total scores...

referencing another sheet and using auto fill
Hi there. I'm trying to create a summary sheet to summarise data from 12 sheets (jan to dec). I have 84 lines each with a member of staff and I need to produce a table with the totals of thei leave in each month. Each seperate month sheet has 84 lines and a total for each person already on it. I need to end up with something like this on the summary sheet: jan feb mar etc total peter's leave totals for month and year: 3 4 1 8 john's leave totals for month and year: 7 2 3 ...

Formula for calculating Gross Profit with muktiple discounts #2
List Price less Disc1 less Disc2 equals Net Price. Sell price less net price equal profit divided by sell price equal gross margin percentage. $10 less 50% less 10% =$4.50. Sell for $12.50. $6.00 less $4.50 =$1.50. $1.50/6.00 = 25% GP. All of these figures are in cells of their own. Cannot get this to calculate correcly. Please help! Urgent CARM Wrote: > List Price less Disc1 less Disc2 equals Net Price. Sell price less net > price equal profit divided by sell price equal gross margi > percentage. > > $10 less 50% less 10% =$4.50. Sell for $12.50. $6.00 less > $4....

matching full name to 'two column' name using sumproduct
Assume your names in Sheet1 are in column A, the dates are in column D, and the values you want to add are in column F. Further assume that the target_name in this_sheet is in A2. Try this formula in a cell in this_sheet: =SUMPRODUCT(--(Sheet1!A2:A100=A2),--(MONTH(Sheet1!D2:D100)=4),Sheet1! F2:F100) This formulae works very well (thanks to Pete for his help), however I need to use the same formulae to match the name in A2 to a spreadsheet that has the name to be matched to in two columns (first name (col A), last name (Col B). I currently use the following to match names i...

How to switch off Outlook2003 out-going warning messages? (Or get Access to use a different email client??)
Outlook2003 + Access2003 under WindowsXP Pro Hi We have a customer list of over 20,000. We are trying to use Access to generate emails in Outlook. The problem we have is that Outlook doesn't like having other programs in this case Access generating AND SENDING emails. It generates a warning message for each and EVERY email saying: "A program is trying to automatically send emails on your behalf" ... "do you want to allow this - it may be a virus" i.e. If we are to sent out 20,000 emails we'd have to click "...

Create Formula
I need to create a formula where I add a set number of Networkdays to a start date. Example: Start Date = 1/2/07 Number of Networkdays = 21 End Date = Is calculated If Start = 1/2/07 and 21 Networkdays are added, what is the retured end date???? I can only find example of Networkdays where I would be providing the Start and End Dates, and it will calculate the Networkdays. I can't find example where End Date is calculated based on the number of networkdays from start date. Can anyone help with a valid formula for this? Thanks!! ...

using depreciation as fixed assets setup
Hello: Instead of typing in the YTD and LTD amounts in the Asset Book window when you are first setting up fixed assets, can you not simply run the depreciation routine and have GP fill in these amounts automatically? Are there any "downfalls" behind doing so? childofthe1980s You might not get the same results if the existing amounts were calculated by hand, Excel, or another fixed assets program. Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com get your gptip42today at www.gp2themax.blogspot.com I've got to go with Fran...

Excel Formula Error for No Good Reason
I don't know why, but this formula will not stop giving me an error in Excel 2003. =IF( $A8 <> "", B8 * E8, IF( ROW(H7) <> 1, IF( G8 = "Subtotal", SUM( H$2:H7 ), IF( LEFT(G8, 3) = "Tax", ROUND( $J$1 * H7, 2), IF( G8 = "Total", INDIRECT( ADDRESS( ROW(H8)-2, COLUMN(H8) ) ) + H7, IF( G8 = "Depr", SUM( INDIRECT( "G2:"&ADDRESS( ROW(H8) - 4, COLUMN(G7),4) ,TRUE) ), "" ) ...

Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a large worksheet simultaneuously. I want to identify the range and then adjust the formula in the entire range. Is there a way that I can highlight the range and then change to formula in each, simultaneously? For example, if I wanted to double the value in the entire range, how would I do this? Thanks, Michael You could put 2 in an empty cell. Copy it Edit|Paste special|click on Multiply under the operation section. Then clear out that 2. But it really depends on what kind of change you're making. If you wanted to ad...

excel formula.
=IF(Sheet1!B4=Sheet1!B1,2,If(Sheet1!B4>Sheet1!B1,1,If (Sheet1!B4<Sheet1!B1,4) In the above formula how would I insert an incremental amount. ie: If(Sheet1!B4>Sheet1!B1,1, the increase to be by two and the result remain one. ie: (Sheet1!B4<Sheet1!B1,4) the decrease be by 1 with the result remaining 4 I am sure that what you want to do is possible, but you have to be a little more descriptive to make us understand. Thanks. Ideally, put up some cell names, put values, then say what you want done. Boris >-----Original Message----- >=IF(Sheet1!B4=Sheet1!...

formula
Hi, I want to copy A1, A3, A5, A7 etc. into a seperate column, but when I try to copy it down, it doesn't seem to recognise my odd numbers request. What formula should I use? Thanks! Use =INDIRECT("A"&ROW(A1)*2-1) and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Georgyneedshelp" <Georgyneedshelp@discussions.microsoft.com> wrote in message news:464A8951-DB29-4907-AE09-AA7CE4F0C15A@microsoft.com... > Hi, > > I want to copy A1, A3, A5, A7 etc. into a seperate column, but when I try to > copy it down, it doe...

What is Process Instance and Process and how do I use it to finetu
Can someone point out a source or explain how the security settings (create, read, wite, delete) work for Process and Process Instance? I have got to believe they can be used to fine tune work flows rules (automatic or manual) but I have seen no real explanation. TIA they allow you to stop users being able to apply workflow rules etc but thats about it ======================= John O'Donnell Microsoft CRM MVP http://codegallery.gotdotnet.com/crm "Henricus" <Henricus@discussions.microsoft.com> wrote in message news:ADCE6D53-2160-4201-BDD2-04ED07877B2C@microsoft.co...

Using SUMIF to add data between a range of dates
Hi, I am developing a cashflow spreadsheet, and need to add a range of values (in column B) based on the criteria that they are relating to a set week, ie in column B has the amount to be paid, and column C has the date the amount is due. I need to find out the total amount due between 2 dates. Does anyone know how I can do this? Hi With start date in B20 and end date in B21 try this: =SUMIF(C2:C5,">=" &B20,B2:B5)-SUMIF(C2:C5,"<="&B21,B2:B5) Regards, Per "Jaspa" <Jaspa@discussions.microsoft.com> skrev i meddelelsen news...

Formula Syntax
Hi I am using the formula below to bring data from one sheet to another. =SUMPRODUCT(--(TEXT(Data!$O$3:$O$5017,"mmm-yy")=TEXT($A9,"mmm-yy")),--(Data! $P$3:$P$5017="Tricia Woodgate"),Data!$Q$3:$Q$5017) However at the end I want to return the sum of Q3+R3:Q5017+R5017. Can someone tell me how to set up the syntax please Thanks A "Alex Hammerstein" <aph@misnet.co.uk> wrote: > Hi I am using the formula below [....]. > > =SUMPRODUCT(--(TEXT(Data!$O$3:$O$5017,"mmm-yy")=TEXT($A9,"mmm-yy")),--(Data! > $P$3:$P$5017=&q...

delete or void unposted cash receipts using econnect 8.0
I need to delete or void unposted cash receipts exist in table RM10201 using econnect. The class which is provided in econnect to void documents “taRMVoidTransaction” works on table RM20101 only which is for posted documents. ...

Using AVERAGEIFS to calculate average rating for programs-Reposted (was unclear)
Here is an example for the Rating database: Date Start Time End Time Channel 1 Channel 2 Channel 3 Channel 4 Channel 5 Channel 6 Channel 7 Channel 8 Channel 9 Channel 10 1/2/2010 06:00 06:15 0 0 0 0 0 0 0 0 0 0 1/2/2010 06:15 06:30 0 0 0 0 0 0 0 0 0 0 1/2/2010 06:30 06:45 0.1 0.1 0.1 0.1 0.1 0 0.1 0.2 0.2 0.1 1/2/2010 06:45 07:00 0.2 0.2 0.1 0.2 0.2 0.1 0.2 0.1 0.1 0.1 1/2/2010 07:00 07:15 0.2 0.1 0.2 0.2 0.2 0.2 0 0 0.1 0.1 1/2/2010 07:15 07:30 2.5 0.1 0.2 0.2 0.2 0.2 0 0 0.1 0.3 1/2/2010 07:30 07:45 2 0.1 0.2 0.2 0.2 0.2 0 0 0.1 0.2 1/2/2010 07:45 08:00 3 4 0.2 4 0...

Excel Array Formula: Multiple Criteria Sum IF Challenge
Currently, I have the following Excel Worksheet Invc No Code Status Charges RejCode 291 CH no pay 50 291 CH no pay 50 291 PY no pay ded 152 CH no pay 50 152 CH no pay 25 152 PY no pay dat 206 CH no pay 50 206 CH no pay 50 206 PY no pay 507 CH no pay 50 507 CH no pay 45 507 PY no pay ded 600 CH overpaid 25 600 CH overpaid 25 600 PY overpaid ded I would like to obtain the following results, Total Charges by Rejecte "no pay" invoices and the specific "no pay" invoices with rejections a displayed below: Total Charges by Rejected "No pay"...

using serial port
Can anyone give me any tips about using a serial port under MSVC++? I'd like to be able to configure the serial port to give me a notification when a carriage return is received and be able to get the line of text. If necessary, I could just receive every character and fill a buffer myself. But I can't just sit there monitoring the port, because I need to do other things in my program. And I'd like to be able to send a line of text out the same port. Ideally, these two things should be allowed to occur asynchronously, but if not I can live with it. I'm using MFC, but if ...

DOS program needing to use net use for network printer
can't use DOS program because Windows XP Pro SP2 and Active Directory issue. Get system error 5. i have been told that i need to make a setting in my Windows 2003 server to allow the client cmd.exe or UNC to work. if i give the local user on the Windows XP computer administrator level access the net use commad works. i currently have the user setup as a power user. ...

Watermark using a picture
Is there a way to create a watermark by inserting an image into the sheet? When I insert an image, it does not want to be grouped behind the text and borders... TIA! DaveyBoy Hi there, Have a look at these examples: http://www.xldynamic.com/source/xld.xlFAQ0005.html Thanks - David ...

the secondary x-Axis. How do I use her?
Hi, my problem is, that I need the primary and the secondary x-Axis, so that I can refer data "A" on the primary x-axis and data "B" on the secondary x-axis. Can anyone help me? Thx ahead What type of chart - Line, column, XY? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "anasne" <anasne@discussions.microsoft.com> wrote in message news:6FD95DA4-7311-459D-B830-EE5C88B7CCA7@microsoft.com... > Hi, my problem is, that I need the primary and the secondary x-Axis, so > that > I can refer data "A" on the primary...

Using formulas to modify pivot table values
Is there a way to modify the output of the data in the body of a pivot table to be included in a calculaton. Of course this can be done post pivot table creation but I would like to do it in one go. I need to divide all the counted values in the body of the pivot table by a cell value, which is different for each row of the pivot table. Help would be much appreciated. --- Chris I don't think so. Maybe you could add an extra column and do your calculation against that (and include it in the pivottable). Or copy the pivottable and convert to values and do what you want. geechr wro...