Multiple IF statements using a dropdown
Using a dropdown column with values: 0, 1-10. 20-100, can you use multiple IF statements in a formula in another column (cell) that states - IF cell = 0 then value equals 1 & IF cell = 1-10 then the value must equal 20 & IF cell = 20-100 then the value equals 50.
Is this possible??
Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!