If logical function with text and numbers

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!
 
B

Bernard Liengme

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
 
F

Francis

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
 
H

Hugo

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!
 
R

Rick Rothstein

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>>,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
Excel Logical function 5
Template with fields and premade texts.. 0
IF AND Function Date Range Issues 6
Use TODAY() function as the criteria in a SUMIF formula 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Paste Link and Link Text From Browser to Word 0
Word macro that can call cells out of Excel for a find and replace 0

Top