Solved

# Using multiple"if" "ands'

Posted on 2014-09-22

Golf tee times.

I have a column "I" that has day name in it i.e. Mon thru Sun.

I have other column "J"that has time in it 0700-1900

I want to show a return value of "T1", "T2", "T3", "T4", "T5"

i.e if ($I14="FRI" and $J14>TIME(10,50,0) then $K14="T1" else "T2")

I need to do this for all seven days. some days have 3 time conditions and 3 'return values.

if ($I14="SUN" and $J14>TIME(10,50,0)<TIME(14,30,0) then $K14="T3" else "T2")

Above probably does not explain well:

7 days

5 Time values

T1-T5 represent values.

If a golfer plays before 1050 on a Saturday that would need to show T1

If a golfer plays after 1051 and before 1700 on a Saturday that would need to show T2

If a golfer plays after 1700 on a Saturday that would need to show T3

So I need to determine the "DAY" from column I and then do the if for each day.

Trying to use one formula for all seven days.

I have wrestled with this for about a month, I can not get it to work for all seven days.

Any direction is appreciated....