HM14
Reputation: 709
how to change cells to a number if it is greater than a number in Excel
I have an Excel spreadsheet with a column of numbers in it. I want to tell it that if a cell in that column is greater than -9999 then I want it to set the value of that cell to -9999. How do I do this in Excel?
Upvotes: 0
Views: 2389
Answers (1)
Related Questions
- How to properly get if a number is between two given numbers in excel?
- How can I pull any cells with a value greater than a number?
- Use ">" (greater than) as a cell reference in IF function
- If a cell value is equal or less than a number, then the resulting value will be in a particular cell
- Changing the value of a cell in excel based on results in a range
- IF Function (less than a value but higher than another value)
- Excel if cell exceeds certain value use difference
- Excel if statement with greater than condition
- Check if a value in a range for a specific key is less than / more than a number
- VBA Excel, if value less than