IF AND OR Enquiry

gmazza76

Well-known Member
Good Morning All,

Quick question if possible.
I have an If/OR formula as below

=IF(OR(\$J\$12="Name1",\$J\$12="Name2",\$J\$12="Name3",\$J\$12="Name4"),"Complaint- Advocate Coaching Document","Complaint - Manager Coaching Document")

This checks a name and changes the header as needed.

I now need to add another variable in but am unsure how to do it.

I have a cell reference ("J11") that can has a list in . I need to change the a comment in a cell as above if it shows "Quality Coaching - Process" it shows "Observations & Discussions - ( Please document a full overview of the process you have checked )" instead of "Observations & Discussions - ( Please document a full overview of your coaching session )"

Can anyone point me in the right direction?

Thanks
Gavin

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Good Morning All,

Quick question if possible.
I have an If/OR formula as below

=IF(OR(\$J\$12="Name1",\$J\$12="Name2",\$J\$12="Name3",\$J\$12="Name4"),"Complaint- Advocate Coaching Document","Complaint - Manager Coaching Document")

This checks a name and changes the header as needed.

I now need to add another variable in but am unsure how to do it.

I have a cell reference ("J11") that can has a list in . I need to change the a comment in a cell as above if it shows "Quality Coaching - Process" it shows "Observations & Discussions - ( Please document a full overview of the process you have checked )" instead of "Observations & Discussions - ( Please document a full overview of your coaching session )"

Can anyone point me in the right direction?

Thanks
Gavin

Hi Gavin,

The highlighted portions appear to be missing information which would help us solve your problem. Could you please amend?

Replies
6
Views
192
Replies
2
Views
131
Replies
0
Views
105
Replies
0
Views
601
Replies
1
Views
187

1,196,480
Messages
6,015,450
Members
441,896
Latest member
clomah

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.

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