If logical function with text and numbers

  • Thread starter Thread starter Hugo
  • Start date Start date
H

Hugo

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!
 
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
 
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
 
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!
 
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>>,"")
 
Back
Top