Forum Discussion
EMonroe1963
Oct 24, 2023Copper Contributor
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
HansVogelaar
Oct 24, 2023MVP
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
Oct 25, 2023Copper Contributor
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
- HansVogelaarOct 25, 2023MVP
I cannot access that workbook, you'll have to share it.
- EMonroe1963Oct 25, 2023Copper ContributorI 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- HansVogelaarOct 25, 2023MVP
Still no access.