LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default If logical function with text and numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help!!! - logical function for someone not very logical ECH123 Excel Worksheet Functions 3 May 11th 09 04:14 PM
How to auto text colour change to green if logical function true? Al Excel Discussion (Misc queries) 1 December 26th 07 12:05 AM
does an IF function only look up numbers & not text? CAPGirl Excel Discussion (Misc queries) 2 October 26th 06 08:20 PM
logical test, array, text and numbers Dan M. Excel Worksheet Functions 1 April 25th 06 08:56 AM
Create a function to return text if two logical functions are true janeyt Excel Worksheet Functions 2 March 19th 05 08:49 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"