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

IF() has three arguments:

=IF(<condition, <true branch, <false branch)

You don't say what you expect TRUE to do, but you may want:

=IF(ISTEXT(C3), FALSE, SUM(F1:F20))

Which if the condition is true (i.e, ISTEXT(C3) returns TRUE), the IF()
function returns FALSE.

If, OTOH, ISTEXT(C3) returns FALSE (e.g., C3 is numeric), then the value
of the false branch will be returned, or SUM(F1:F20))



In article ,
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

Same problem -- too many arguments for the IF() function.

Try this instead:

=IF(ISTEXT(C3),SUM(F1:F20),"")

or

=IF(ISTEXT(C3),"",SUM(F1:F20))

If you are trying to sum F1:F20 only if C3 is a text entry, go with
the first formula, otherwise use the second.

HTH,
JP


On Nov 20, 9:31 am, 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

@ JP
@ JE

Thank you both very much. I shall go through both responses so tthat I
understand them - then it will be so easssssssssssy next time round
FG

"JP" wrote:

Same problem -- too many arguments for the IF() function.

Try this instead:

=IF(ISTEXT(C3),SUM(F1:F20),"")

or

=IF(ISTEXT(C3),"",SUM(F1:F20))

If you are trying to sum F1:F20 only if C3 is a text entry, go with
the first formula, otherwise use the second.

HTH,
JP


On Nov 20, 9:31 am, 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

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

"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.

@Ron
@ Stephen

Many thanks guys
FG

"Stephen" wrote:

"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.