Multiple If Statements

[Graham C1600]

Hi,

My query is I want column D to look at F3 and also check the time as per colums C to deliver a specific number.
So in D3 I have the following - =IF($F$3="","",IF(AND(C3<$C$10,$F$3="Standard"),2,1)). So this is checking the time is before 07:30 (Column C) and Standard is in F3. I want to add an additional check to say if F3 says Adhoc then put a number 3 in D3.
So in essence it's checking time first then what it says in F3.

Hope this makes sense.

Thanks

 

[etaf]

does this work for you

=IF($F$3="","",IF(AND(C3<$C$10,$F$3="Standard"),2,IF(AND(C3<$C$10,$F$3="Adhoc"),3,1)))