Jun 24 2018 04:33 PM
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
Jun 24 2018 10:32 PM
Hayden,
please provide a complete description of your problem.
Jun 25 2018 06:33 AM
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 |
Jun 25 2018 07:26 AM
Hi,
try this:
=IFERROR(D9/E9,IF(C9>TODAY(),"Future","Vacation"))
Jun 25 2018 07:30 AM