I've attempted to create an IF formula to input specific text dependent on the range of value.
IF(G8<=59%,"Fail", "N/A")+IF((AND(G8=60%,G8<=79%),"Pass - Action Required", "N/A"))+IF,(((AND(G8>=80%,G8<=100%), "Pass", "N/A"))))
I can't get this to work.
Hope you can help!!!!!!!
Bookmarks