# if and or function

1. ### 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...
2. ### 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...
3. ### 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