Results 1 to 4 of 4

Thread: Isformula Excel 2010

  1. #1
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019

    Isformula Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Excel users,

    I am surprised that Excel 2010 does not have an isformula function. Is there an alternative way to test for a formula without using code or user defined functions?

  2. #2
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    78
    Articles
    0
    Excel Version
    2013
    How about
    =NOT(ISNA(FORMULATEXT(B4)))

  3. #3
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019
    Thanks Fluff,

    Excel 2010 does not have the FormulaText function either. That is OK. I think I can get by without this function.

  4. #4
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    78
    Articles
    0
    Excel Version
    2013
    Apologies for that, I thought that it came in 2010, obviously not

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •