Hi,

I have a row with dates. Every three cells are a date in months, which excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo

One way, something like this in say, B2, copied down:
=IF(ISTEXT(A2),"",yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Hugo" wrote:
I have a row with dates. Every three cells are a date in months, which excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo

Should be the other way around, sorry:
=IF(ISTEXT(A2),yourformula,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Would there be a way to have the cells, which don't fit the logical
function's criteria to not have any formula in these at all? Ideally, I
would like only the cells that fit the criteria of the header being text to
have my formula, whereas the cells that do not meet this criteria should be
for inputting data points in a time series.

Thanks for everyone's help!
--
Hugo


"Max" wrote:

Should be the other way around, sorry:
=IF(ISTEXT(A2),yourformula,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Suggest you try a fresh posting in .programming for your new query
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Hugo" wrote in message
...
Would there be a way to have the cells, which don't fit the logical
function's criteria to not have any formula in these at all? Ideally, I
would like only the cells that fit the criteria of the header being text
to
have my formula, whereas the cells that do not meet this criteria should
be
for inputting data points in a time series.

I started with a date in A1 and used this formula in another cell
=IF(ISERROR(A1+1),"A1 is text","A1 is a number")
It returned "A1 is number"
When I overtyped the date with text it returned "A1 is text"
Remember that dates in Excel are actually numbers being displayed is a
specific way
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Hugo" wrote in message
...
Hi,

I have a row with dates. Every three cells are a date in months, which
excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the
date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo

Hi

Not sure how do you return the SUM if your data are text?

try this as to your requirement
=IF(ISNUMBER(A8),"",Your Formula)

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Hugo" wrote:

Hi,

I have a row with dates. Every three cells are a date in months, which excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo

I presume this is a follow up to your previous posting in the programming
newsgroup. If so, then you can do something like this...

=IF(LEFT(E2)="Q",<<YourSumFormula,"")

--
Rick (MVP - Excel)


"Hugo" wrote in message
...
Hi,

I have a row with dates. Every three cells are a date in months, which
excel
recognizes as a date, but every fourth cell is the quarterly date, which
excel recognizes as text.

I would like to write an if function that can discriminate between the
date
values and the text values. In words, what I would like it to do is this:
"if a cell is text, return a sum, if not, return nothing".

Any help would be greatly appreciated.

Thanks!
--
Hugo