=IF('M ORQ Rec'!B2=0,0,IF('M ORQ Rec'!B2>=12,20,IF('M ORQ Rec'!B2>=10,18,IF('M ORQ Rec'!B2>=7,16,IF('M ORQ Rec'!B2<=6,15,"N")))))
I want it to display N if there is text in B2, but it always shows 20 instead. Thanks
=IF('M ORQ Rec'!B2=0,0,IF('M ORQ Rec'!B2>=12,20,IF('M ORQ Rec'!B2>=10,18,IF('M ORQ Rec'!B2>=7,16,IF('M ORQ Rec'!B2<=6,15,"N")))))
I want it to display N if there is text in B2, but it always shows 20 instead. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks