two conditions with three answers

[Hayden Alston]

I'm trying to write a formula that check two conditions and puts a individual answer for both or if both are true it will put a specific answer.

If (Condition 1) is true put (Result 1) if (condition 2 ) is true put (result 2) and if both are true put (result 3)

=IFS(D9<=0,"Vacation",C9:C11>6/24/2018,"Future",AND(C9:C11>6/24/2018,D9<=0),D9/E9)

this is what my clueless self put together from trying to learn online 

[#2]

Hayden,

please provide a complete description of your problem.

[#3]

I'm determining the average hourly pay of 2018 (because I was bored) and have my payday (every Thursday), the paycheck amount, and the hours worked. On my sheet I have every Thursday of 2018 I wanted a formula that would calculate the average hourly pay if the date was before the present day if it was a future day it would put Future in the Hourly Pay column and if the cells I was using to calculate the hourly pay were empty any day before present day it would put Vacation.

PAYDAY	PAID	HOURS	HRLY PAY
6/24/2018	349.23	54.23
6/25/2018
6/26/2018

[#4]

Hi,

try this:

=IFERROR(D9/E9,IF(C9>TODAY(),"Future","Vacation"))

[#5]

Thank You it worked. I tried for a hour or two to figure that out before I posted on here