using two IF formulas

[MattGriff]

Hi guys, after the help of the experts for work again.

I have a spreadhseet with various functions on it and what I am trying to do is this.

Cell E4 returns a >35 or <35 true or false value
Cell G4 is either blank or has "Yes" text type into it.

What I am trying to do is get cell F4 to return certain arguments.

E4 = >35 and G4 is blank I want it to state "Email Hiring Manager"
E4 = ,35 and G4 is blank I want it to state "Wait"

I have a basic IF formula that returns this
=IF(E4>35,"Email Hiring Manager","Wait")

Then if cell G4 is populated with a Yes the formula needs to overwirte the origonal if with the return arguments of
=IF(G4="Yes","Email Agency","Email Hiring Manager")

If yes then what would be Email Hiring Manager (yes will only be input if E4 is greater than 35) will be overwritten with "Email Agency"

Can this be done with two If formulas or does there need to be 3 or more to count if other IF formulas are actually returning a value?

Sorry for waffling

[Cheeky Charlie]

It was a bit of a waffle... made me quite hungry in fact...

Rather than patronise you, this should be enough:
You can nest if functions by simply inserting a new if() as one of the results of another:
=if(<result>,a,if(<second result>,b,c))
(could be done similarly for "true" argument)

HTH

[MattGriff]

Feel free to patronise, I can't get it to work

I can get parts of it to work, I tried using cell G4 as the primary referance (the logic test for IF) as it overwrites anything referance from E4 if there is a Yes in it but I can't seem to get my head around this one

its basically 3 things to be in the destinationh cell

If E4 False and G4 blank = Wait
If E4 True and G4 blank = Email Hiring Manager
If E4 true and G4 = yes = Email agent

Its just returning two arguments each time

[zbor]

=IF(G4="";IF(E4;"Email Hiring Manager";"Wait");IF(AND(E4;G4="Yes");"Email agent";"chek again"))

(replace ; with , if needed)

[NBVC]

Maybe something like this:

=IF(G4="",IF(E4=TRUE,"Email Hiring Manager","Wait"),IF(AND(G4="Yes",E4=TRUE),"Email Agent",""))

[MattGriff]

great stuff thank you guys for your help!