I'm such a noob... This should be simple but I can't find a formula that works with everything needed. If this could be all one formula for cell A1 that'd be great.
If B1 is blank, leave A1 blank
If B1 is 1 make cell A1 say 1
If B1 is 2 make cell A1 say 1
If B1 is 3 make cell A1 say 2
If B1 is 4 make cell A1 say 2
If B1 is 5 make cell A1 say 3
If B1 is 6 make cell A1 say 3
Thanks!!
Bookmarks