1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Re: Formula to identify decimal versus whole numbers

    From Jennifer Yeh@21:1/5 to All on Thu Mar 9 19:17:17 2023
    Re: formula to identify decimal versus whole numbers

    I don't think anyone has offered this solution yet...
    Assuming A1 contains the number you're trying to assess, use this formula: =if(round(A1)=round(A1,2),"integer","decimal")

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)