|I am assuming that by "if value is 900.00 to 949.99 " you are refer to a value is a specific cell and by "then cell is 100" you are referring to the cell where the formula resides.|
In other words, with the formula in B1, you are looking at the value in A1.
If so, there are 2 methods:
A Nested IF function would look like this:
However, there are 2 issues with this solution:
1 - You didn't tell us what you want the formula to rerun if the value is less than 900. As written, that formula will return FALSE since this condition is not specifically addressed. In other words, we haven't told Excel what to do if none of the conditions are met.
That issue can be solved by telling Excel to return an empty for any value that doesn't meet any of the specified conditions:
2 - This may not be an issue, but you only have 2 decimal places in your conditions, e.g. 999.99. While your cell may display 999.99, if that value is the result of a calculation,
the actual value that Excel may use could be 999.991. If we were to use your exact values, we would need to tell Excel what to with values between e.g. 999.99 and 1000.
As written, the formula I posted will use <1000, as opposed to =999.99, which handle 999.991 very well. If there is some reason that you need to restrict your conditions to xxx.99, the formula will be more complicated, but can still be written.
OK, there is also another method that uses VLOOKUP.
If you create a table with your values, you can use a much simpler formula. If you use the VLOOKUP method, you can change the values in the table and not have to touch the formula should any of your criteria change in the future.
For example, if you start with this table:
2 900 100
3 950 200
4 1000 300
5 1050 400
6 1100 500
You can use this formula:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.