Istext

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;757685

IF() 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...