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
=MATCH(C3, {"0-250M","250M-500M","500M-1B","1.1B-2B","2.1B-3B","3.1B-4B","4B+"}, 0)
Thank you for your response. This resulted in placing a "1" for cells with 0-250M but #N/A for all other cells