Forum Discussion

EMonroe1963's avatar
EMonroe1963
Copper Contributor
Oct 24, 2023

I am trying to create an IF statement that is able to determine incorrect capitalization

I am trying to create an IF statement with 4 columns of data that needs to determine incorrect Capitalization but not give out FALSE answer when the data includes number

excel
Formulas and Functions

5 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 24, 2023

    EMonroe1963 

    Could you attach a small sample workbook with some non-sensitive data and the expected output, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

    • EMonroe1963's avatar
      EMonroe1963
      Copper Contributor
      Oct 25, 2023

      HansVogelaar   What I need is a IF statement that will determine if Capitialization is correct in 4 columns (J,K,L,M) (I blanked out all of the data in the other columns for data reasons.) I need column O to read out TRUE/FALSE .

      https://generac-my.sharepoint.com/personal/edward_monroe_generac_com/Documents/Formula%20Practice%20File.xlsx?web=1