High and lower case text in the "if" functions
Solved/Closed
Joshte
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
Mar 7, 2013 at 10:21 PM
Joshte Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013 - Mar 8, 2013 at 07:48 PM
Joshte Posts 3 Registration date Thursday March 7, 2013 Status Member Last seen March 9, 2013 - Mar 8, 2013 at 07:48 PM
Related:
- High and lower case text in the "if" functions
- Accessor and mutator functions c++ - Guide
- Hard disk parts and functions - Guide
- What are the key functions of the supportassist for home pcs? - Download - Cleaning and optimization
- Excel functions in french - Guide
- Spreadsheet functions - Guide
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 8, 2013 at 05:46 PM
Mar 8, 2013 at 05:46 PM
Hi Joshte,
Your structure of the cells and formula is correct; you need to make a little change in the formula. Replace the formula with the below one instead:
=IF((EXACT(UPPER(A6), A6)),"OVER",0)
Do reply with results.
Your structure of the cells and formula is correct; you need to make a little change in the formula. Replace the formula with the below one instead:
=IF((EXACT(UPPER(A6), A6)),"OVER",0)
Do reply with results.
Joshte
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
Mar 8, 2013 at 07:48 PM
Mar 8, 2013 at 07:48 PM
Yes, it worked Zohaib.
Thank you.
Thank you.