Hi there,
If cell F23 displays < 70%, I want it to display "Fail" in G23
If cell F23 displays = or > than 70%, I want it to display "Pass" in G23
If cell F23 displays blank, I want it to display "Not Evaluated"
I'm using Excel 2007. How would I go about accomplishing this?
If cell F23 displays < 70%, I want it to display "Fail" in G23
If cell F23 displays = or > than 70%, I want it to display "Pass" in G23
If cell F23 displays blank, I want it to display "Not Evaluated"
I'm using Excel 2007. How would I go about accomplishing this?