If(or(and())) help request

[whostean]

Hello,

I am trying to put together an expression that will pre-fill a [FEE] column, based on the customer’s [MEMBERSHIP LEVEL] and the current time. We have 3 different membership levels (level 1, level 2, and coach).
If a Level 1 begins their rental before 9:20, their rate is $10/ hour. If a Level 1 begins their rental after 9:20, their rate is $16/ hour.
A Level 2 receives the $10/ hour rate any time.
A Coach receives a rate of $0/ hour (free.)

IFS(OR(AND([LEVEL]= “LEVEL 1”, [TIME OUT] < (009:20:00)), [LEVEL] = “LEVEL 2”), 10, AND([LEVEL] = “LEVEL 1”, [TIME OUT] > (009:20:00)), “16”, [LEVEL] = “COACH PASS”, “NO CHARGE”)

I’m getting “Arithmetic expression ‘([TIME OUT] < “009:20:00”)’ does not have valid input types”

Any suggestions are greatly appreciated!

[LeventK · Accepted solution]

@whostean
Try with this:

IFS(
	[LEVEL] = "LEVEL 1",
	IF(
		[TIME OUT] <= "09:20:00",
		10,
		16
	),
	[LEVEL] = "LEVEL 2",10,
	TRUE,0
)

[whostean]

That was it! Thank you so much. I spent HOURS trying to figure that out… I really appreciate your help!

[LeventK]

You’re welcome.