High and lower case text in the "if" functions

[Solved/Closed]
Report
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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.
Posts
3
Registration date
Thursday March 7, 2013
Status
Member
Last seen
March 9, 2013

Yes, it worked Zohaib.
Thank you.