Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
How to auto text colour change to green if logical function true? | Excel Discussion (Misc queries) | |||
does an IF function only look up numbers & not text? | Excel Discussion (Misc queries) | |||
logical test, array, text and numbers | Excel Worksheet Functions | |||
Create a function to return text if two logical functions are true | Excel Worksheet Functions |