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
Hello,
I am working on a basketball spreadsheet.
I am keep track of the home teams straight up(SU) wins.
Home teams are capitalized(higher case), the visiting team, lower case.
There is a column for "Winner Straight Up".
How would I could use the "IF" formula to add to the "Over" column if the team in the WSU is all in higher case text?

Ex cell A6 BOSTON
cell A7 denver

If formula "IF(A6="????";1).
This is just a guess, but something like that.
Thank you



2 replies

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
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.
0
Joshte
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013

Mar 8, 2013 at 07:48 PM
Yes, it worked Zohaib.
Thank you.
0