I have a list of numbers in column E.
Example:
0.01
0.03
0.02
I'm trying to create a formula that shows:
> 0.69 is high, < 0.69 and > 0.34 is medium and the rest is low
I tried the below formula but I think I'm not even close...
=IF(E2>0.69,"High",IF(E2>0.69,"Medium",IF(E2>0.34,"Low")))
Any ideas?
Bookmarks