# Trouble nesting an IF statement

#### Kezza223

##### New Member
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

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
=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:")))))

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.

=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.

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

Try
Code:
``=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

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>

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:"))))))

Replies
6
Views
175
Replies
5
Views
216
Replies
0
Views
86
Replies
1
Views
202
Replies
3
Views
184

1,203,379
Messages
6,055,095
Members
444,761
Latest member
lneuberger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back