Trouble nesting an IF statement

[Kezza223]

Hi

I am having trouble getting a formula to work.

so far I have this:

=IF(B8="Change to Day working"," ",IF(B8="Change of Manager"," ",IF(B8="Change to Team"," ",IF(B8="Change of Hours"," ",IF(B8="Change to Hourly Rate"," ","Manager to Complete:")))))

What I also want it to do is sayis ..... IF B8="Change of Manager" and the value in cell B21 is > 35 enter "Manager to Complete" else enter nothing, but i am not sure how to enter this in the already nested IF statement.

any ideas?
Many thanks

 

[dafan]

=IF(B8="Change to Day working"," ",IF(AND(B8="Change of Manager",B21>35),"Manager to complete",IF(B8="Change to Team"," ",IF(B8="Change of Hours"," ",IF(B8="Change to Hourly Rate"," ","Manager to Complete:")))))

 

[Kezza223]

Brilliant thanks for your reply.

it is working, but the "Manager to Complete" is entering in the cell even if B21 is < 35, i would like the cell to stay blank if B8 "Change of Manager" is < 35.

 

[dafan]

=IF(B8="Change to Day working"," ",IF(AND(B8="Change of Manager",B21>35),"Manager to complete",IF(B8="Change to Team"," ",IF(B8="Change of Hours"," ",IF(B8="Change to Hourly Rate"," "," ")))))

I guess.

 

[Kezza223]

Hi

that didnt work it is still populating "Manger to complete" in the cell even if it is under 35 in B21, it looks like it is ignoring " ".

any ideas

thanks

 

[lenze]

Try

=IF(B8="Change to Day working","",IF(OR(B8="Change to Hourly Rate",AND(B8="Change of Manager",B21>35)),"Manager to complete",IF(B8="Change to Team","","")))

lenze

 

[Kezza223]

Hi

thank you so much for your help so far

Everything else is working (I have changed some of the wording but the principle is still the same) the formula is still not removing the "Adviser to Sign Off" when B21 is = to or <35 for "Change of Hours"

when B21 is < 35 for "Change of Hours" I would like cell to stay blank and only display "HR Adviser to Sign Off" if the value in B21 is >35.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=IF(B8="Change to Cost Centre"," ",IF(B8="Change to Salary"," ",IF(B8="Change to Job Title"," ",IF(OR(B8="Change of Hours",AND(B8="Change of Hours",B21>35)),"HR Adviser to Sign Off",IF(B8="Change to Reporting Line","","HR Adviser to Complete")))))

any ideas?

thanks
<o></o>

 

[Kezza223]

I have cracked it !! it is now working!!


thanks to all that helped

I used the following formula (and now i have a headache!!)

=IF(B8="Change to Cost Centre"," ",IF(AND(B8="Change of Hours",B21>"35"),"HR Adviser to Sign Off:",IF(AND(B8="Change of Hours",B21<"35")," ",IF(B8="Change to Reporting Line"," ",IF(B8="Change to Job Title"," ",IF(B8="Change to Salary"," ","HR Adviser to Complete:"))))))