range of values

  1. A

    Compare Cells above and below the current cell and check for greater value and sum

    In the below row Let say my current cell is 8. Now i need to check the above and below cell of current cell (8) on which is greater, and that greater value shud be added with current cell Cell above current cell is greater so 6+8 =14 Now check the next above cell(7) with cell below current cell...
  2. C

    Creating IF function to check between a range of values

    I'm trying to create an IF function where the logical test involves a search between a range of values. I'm want to have a cell that searches a defined set of cells (e.g. C4:C100) for numbers that fall between two values, if it finds a number that falls between those two values, then it will...
  3. K

    Help on IF formula, values from 175-260

    I have values in a worksheet that are from 175 - 260 and I want to but a score on them in a separate column (B). values of >= 260 will be 50, 200-225 will be 45, 175-199 will be 40. Here is my formula, and it is only putting a value in cells that have 260. everything else is getting 0's. :(...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top