My bad. I interpret E8/D8 as E8 or D8 haha.. Let's try again
=IFERROR(IF(AND(E8/D8<=20,RIGHT(B8,1)="C"),"B Pack Needed","B Pack Not Needed"),"")
My bad. I interpret E8/D8 as E8 or D8 haha.. Let's try again
=IFERROR(IF(AND(E8/D8<=20,RIGHT(B8,1)="C"),"B Pack Needed","B Pack Not Needed"),"")
Last edited by JieJenn; 05-19-2012 at 10:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks