On Tue, 20 Nov 2007 06:31:07 -0800, Finance Guru
wrote:

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

Well, you didn't still didn't post what you are trying to do, so that makes
things difficult.

Perhaps it is this:

=IF(not(ISTEXT(c3)),sum(F1:f20),TRUE)


--ron