negative numbers

  1. E

    text determines value

    Hi all, New to the forum and also Macros. I am trying to write code to make a cell default to a negative value based on the text of another cell. For example: if the cell states "EXPENSE" then the offset(0,1) will be a negative figure when the numbers are entered into that cell. Any help...
    • EXCEL_ED
    • Thread
    • negative numbers number format text criteria text formula
    • Replies: 2
    • Forum: Excel Questions
  2. H

    Conditional formatting, formula for the top 5 negative numbers for a row.

    Row A1 - FX1 of negative/positive numbers -600 to 1100. I want to know which ones are the highest negative number (top 5) in the row. Thanks for your help in advanced.
    • hotrod
    • Thread
    • conditional formatting formula negative numbers
    • Replies: 4
    • Forum: Excel Questions
  3. S

    Sumif and ignore negative numbers...

    I have tried a few options that I have found on the boards but I have not been successful... My existing formula is working but I have now realized that there is sometimes negative numbers in the S - X columns and I need to ignore them. My existing formula: =SUMIF('Sales Orders...

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