Posted to microsoft.public.excel.worksheet.functions

Finance Guru Finance Guru is offline

external usenet poster

Posts: 83

IFISTEXT() function problem

Hi Everyone

Could some one enlighten as toi what is what is wrong with this function
Excel keeps telling me there is an error,and keeps putting an * before the
TRUE
=IF(ISTEXT(c3),FALSE,sum(F1:f20),TRUE)

C3 = 999
F1 : F20 contain various numerical amounts

so if C3 is False,which it is then ???? i stumped
As always
Many thanks to all respondents

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
Mid Function Problem	DEI	Excel Discussion (Misc queries)	3	August 9th 06 08:08 PM
Function problem	Sweeny	Excel Worksheet Functions	8	October 17th 05 12:13 AM
if Function problem	jerry	Excel Discussion (Misc queries)	8	October 3rd 05 06:18 PM
FV Function Problem	TerryG	Excel Worksheet Functions	3	June 13th 05 09:26 PM
IF function problem	dvonj	Excel Worksheet Functions	13	March 10th 05 01:13 PM

All times are GMT +1. The time now is 02:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us