Can anyone give me a simple interpretation of this formula
=SUM(IF(ISTEXT(A2:E2))
Can anyone give me a simple interpretation of this formula
=SUM(IF(ISTEXT(A2:E2))
Re: Istext
IsText() returns True or False depending if the value being checked is Text (Not Number/Date/Boolean).
IF() needs 2 parameters, The True Part and the False Part
Sum() does as it says - it sums values.
Your formula may not work as written. What did you want to do?
Re: Istext
Quote from cytop;757685IF() needs 2 parameters, The True Part and the False Part
Actually the second, value_if_false parameter is optional.
(Strangely, this site suggest that so too is the first parameter - that would be an interesting formula indeed, i.e. =IF()!!)
Regards
Re: Istext
Just keeping it simple and covering all eventualities...
Don’t have an account yet? Register yourself now and be a part of our community!