two conditions with three answers

Highlighted
Occasional Contributor

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 

4 Replies
Highlighted

Hayden,

 

please provide a complete description of your problem.

 

 

Highlighted

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.

PAYDAYPAIDHOURSHRLY PAY
6/24/2018349.2354.23 
6/25/2018   
6/26/2018   
Highlighted

Hi,

 

try this:

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

 

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