Thread: [Solved] Conditional query ...
View Single Post
 
Old 02-05-2018, 06:11 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

That does not take into account the "nothing" condition...

=IF(OR(ISBLANK(A2),LEN(A2)<13),"Grade-B","Grade-A")
Reply With Quote