• 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!