# if and or function

1. ### Spill formulas with IF and OR

I have the table below, looking to create a spill formula which will simply tell me if a numeric value is in any of the three columns B,C,D. However with the spill formula currently in use as soon as one row is true then all become true. Is this a limitation to spill formulas or is there a...
2. ### IF AND OR or is it IF OR AND

Here I am again, coming those more experience than I I have tried multi variations of the this formula S9 = TASK1 OR TASK2 T9 = Score for TASKS >=.75 IF TASK1 or .85 IF TASK2 U9 = SUM of F9:R9 (F9 G9 H9 I9 to calculate score for TASK1) and (F9 G9 H9 I9 J9 K9 L9 M9 N9 O9 P9 Q9 R9 to...
3. ### Nesting Formulas

hi I am struggling to put together a number of formulas to get the required result I am after. I started off using the IF function and then tried the IFS function, but have not been able to put them together. Each of them works individually, but I have not been able to get the correct syntax...
4. ### Help with what route to go with function

I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...

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