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

Question

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

hansvogelaar · Answer

EMonroe1963&nbsp;
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 · Answer

HansVogelaar&nbsp; &nbsp;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

hansvogelaar · Answer

EMonroe1963&nbsp;
I cannot access that workbook, you'll have to share it.

emonroe1963 · Answer

I opened the access. See if this works. If not, I will try to go through dropbox if I can get it through my work.https://generac-my.sharepoint.com/personal/edward_monroe_generac_com/Documents/Formula%20Practice%20File.xlsx?web=1

hansvogelaar · Answer

EMonroe1963&nbsp;
Still no access.

Forum Discussion

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

Share

Resources