Using Named Ranges in If functions
I tried to put in a function with named ranges but the formula did not work.. It came out as #Value!
This is the actual formula but I want to reduce it because its very long
= IF(OR(A2>=8,A3>=8,A4>=8,A5>=9,A6>=9,A7>=10)"Not Completed","Completed")
If I named range from A2 to A4 =UNI8 and
A5 to A6 = UNI9
Can I put the formula as
Looking forward to some feedback please!