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
Thank you to all for your responses. I was able to solve the issue by adjusting the range verbiage from using a "-" to "to". This removed the thought of an equation and simplified to a text lookup.