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