 Highlighted

# two conditions with three answers

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,

Highlighted

# Re: two conditions with three answers

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
Highlighted

# Re: two conditions with three answers

Hi,

try this:

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

Highlighted

# Re: two conditions with three answers

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