Forum Discussion
Solved
Need help with an IFS formula
I have static ranges in each cell that are listed below and I need to add weights of 1 through 7 based on range in cell. I tried the following formula and it failed as well as trying 2-3 others with ...
- Thank you for your response. This resulted in placing a "1" for cells with 0-250M but #N/A for all other cells
That could be like
=lookup(c3, {0, 250e6, 500e6, 1.1e9, 2.1e9, 3.1e9, 4.1e9}, {1,2,3,4,5,6,7} )- Though correct, I would suggest not to hard-code values in formulas SergeiBaklan
For actual data I also do not recommend to hardcode. At the same time without knowing of data and Excel version it's hard to recommend to use new table, or use existing range, or use named array constant.
Just a pattern.
