[mso] Re: (No Date: Wed, 29 Oct 2008 21:04:25 +1100

Hi David, thank you so much - of course, I didn't think of it as a
formatting problem, you have assisted me greatly - a biiiiiiiiiiiiiig thank
you!

Cheers
Pauline


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of David Smart
Sent: Wednesday, 29 October 2008 19:05
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: (No Date: Wed, 29 Oct 2008 21:04:25 +1100

1) this group doesn't allow attachments
2) your message doesn't have a subject

3) ... I think you might have a formatting question, rather than a cell 
contents question.

Tests like IF or VLookUp will happily check the value of a cell, even when 
it has a formula in it.  Anything else would cripple VBA.  So, the presence 
of a formula shouldn't change things.

However, dates are stored internally as numbers of days since 1901.  I.e. 
the actual month does not appear anywhere in the cell, but is automatically 
formatted for display when needed.

So, you can look for the word April, if and only if there is a cell that has

the string April in it or can produce it.  There are two ways of doing this 
that spring immediately to mind:

a) put the string April into a cell (without any other date information at 
all).  Then you can use formulas at will - you're playing with a string with

"April" in it, not a date.

b) test against the month name explicitly extracted from the date field. 
E.g. =IF(TEXT(G20,"mmmm")="April","yes","no")

I now note you actually talk about apr, not April.  That's one fewer m's. 
E.g. =IF(TEXT(G20,"mmm")="Apr","yes","no")

Regards, Dave S

----- Original Message ----- 
From: "Pauline Wood" <pauline.wood_ayft@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Wednesday, October 29, 2008 1:11 PM
Subject: [mso]


> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
> What I am trying to do with the attached excel spreadsheet is to place an 
> IF
> formula in each of the cells within the black border.
> The formula cold be something like this: IF(row 4 = "april" then place a
> number (say 1).  The problem I am facing is that even though the cells in
> row 4 show names of months, the cells themselves obviously contain 
> formulas
> so when I place in the IF formula to search for the month of April, it 
> isn't
> doing it as it is looking at the relevant cell and seeing a formula not a
> word. Is there any syntax to tell the formula to look at the text of the
> cell rather than the formula ie the formula looks at "i4" and sees "Apr"
> rather than seeing  "Date(year(...),Mont(...)+...,1)"?
>
>
>
> Kind regards
> Pauline Wood
>
>
>
>
>
>
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or

> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow you
to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.175 / Virus Database: 270.8.4/1753 - Release Date: 10/28/2008
9:20 PM

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: