Hi guys, I'm having problems with creating the conditional formula for the below data.
Cell D4 contains the value that needs conditional formula computatuion.
4 >=75%
3 <75%, >=70%
2 <70%, >=65%
1 <65%
These is how I'm writing the formula but it doesn't seem to work (Note: D4 contains the cell value)
=IF(D4>=75%,4,IF(D4<75%>=70%,3,IF(D4<70%>=65%,2,1)))
Many Thanks!
Bookmarks