"Finance Guru" wrote in message
...
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

The IF function only takes 3 arguments and you have 4.
It should look like this:
=IF(condition, expression_if_true, expression_if_false)

If you want the sum of F1:F20 when C3 is text, it should start
=IF(ISTEXT(C3),SUM(F1:F20), ... )
where ... means "what do you want if C3 is not text?"

If you want the sum of F1:F20 when C3 is NOT text, it should start
=IF(NOT(ISTEXT(C3)),SUM(F1:F20), ... )

Hope this helps.