IFISTEXT() function problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))
 
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
 
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
Click to expand...

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 said:
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
Click to expand...

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.
 
@ 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
 
@Ron
@ Stephen

Many thanks guys
FG

Stephen said:
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.
Click to expand...
 
Back
Top