IF statement based on data type

Reed

Posts: n/a

IF statement based on data type

Hi,

Is there a way to have an if statement based on data type. Here is the
equation I am using.

=IF($F10="",E11,E11+F10)

As you can see I can not add E11 and F10 if F10 is text. I want say
IF($F10="IS TEXT",E11,E11+F10). I hope what I want to do is clear, please
let me know if clarification is needed.

Thanks,

Reed

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
populating sheets based on data from parent sheets	seve	Excel Discussion (Misc queries)	2	January 15th 05 09:22 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM
Convert data type of cells to Text,Number,Date and Time	Kevin	Excel Worksheet Functions	1	December 31st 04 12:57 PM
Convert data of cells to any type: Number, Date&Time, Text	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 06:55 AM
Can you average data in 1 column based on a range of values in another?	kman24	Excel Worksheet Functions	2	November 17th 04 02:09 PM

All times are GMT +1. The time now is 11:39 PM.

Menu

About Us