unchanged

  1. W

    Formula to find, change and highlight Cell based on Specific criteria

    I have three columns of data, Assignment, Category, and Amount. What I need is to find when the Category is equal to USOCOO, within each Assignment, then find the Category with the highest Amount, then change the "USOCOO" to the highest Category and change cell color to 0.799981688894314. Here...
  2. M

    How to manipulate boxes

    How do you make a box or column wider for a certain area while leaving the rest of the column below unchanged? Thank you in advance.
  3. H

    Formula to convert anything above decimal 7 to 9

    Hi, I would like to convert the decimal which is equal or higher than .70 to .99 For eg. 12.75 changes to 12.99 10.82 changes to 10.99 else all the other figures remains unchanged 10.39 does not change 19.69 does not change Thanks in advance Hiten
  4. S

    IF Statement with a Value Unchanged

    So I have a couple cells, 2 of them are dates of contract starts and ends. I then have cells which contain the current Trade Up Quote that changes every 3 months. I want to create an IF statement within the cells that contain the Trade Up Quote values that shows when the contract end date is...
  5. S

    Fixing cells ($) for multiple cells

    I know I can put a $ sign for all references in a formula for a cell by pressing F4, but is there a quick way for doing this for multiple cells (e.g. a column) or do I have to go through all the cells individually? e.g. =A1 =A2 =A3 to =$A$1 =$A$2 =$A$3 Thanks

Watch MrExcel Video

This Week's Hot Topics

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
Top