Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have this formula in one cell, dragged down through more than 800 rows and
it's working fine: =IF(G7<=15,"2 WKS",""). But, for the life of me, I can't come up with the next one I want, which is IF G7 is more than 14 but less than 22, return "3 WKS". I have checked online help and there's lots of help there, but can't find this particular one. Connie |