Cell Tab
 |
 INTEX Krystal Clear Saltwater System Chlorinator w GFCI $189.00 Time Remaining: 23d 9h 47m Buy It Now for only: $189.00 |
 INTEX Krystal Clear Saltwater System Chlorinator w GFCI $188.00 Time Remaining: 3d 12h 7m Buy It Now for only: $207.95 |
 INTEX 2000 GPH GFCI Saltwater Chlorinator Swimming Pool Pump 6 Type B Filters $299.00 Time Remaining: 22d 23h 1m Buy It Now for only: $299.00 |
 New Water Tech Aqua Broom Swimming Pool Spa Suction Cleaner Battery Vacuum $42.70 Time Remaining: 12h 27m |
 INTEX Krystal Clear Saltwater System Pool Chlorinator $189.00 Time Remaining: 3d 1h 32m Buy It Now for only: $189.00 |
 NEW Unsinkable Sport Swimming Pool Float Blue $63.95 Time Remaining: 11h 39m |
 HAYWARD AQUA TROL AQ TROL RJ Salt Chlorine Generator $422.95 Time Remaining: 24d 6h 17m Buy It Now for only: $422.95 |
 INTEX 1600 GPH Saltwater System Sand Filter Pump Set $349.00 Time Remaining: 13d 1h 21m Buy It Now for only: $349.00 |
 GOLDLINE HAYWARD TCELL 3 Aquarite Turbo Cell Chlorinator Swimming Pool TCELL3 $208.00 Time Remaining: 10h 36m |
 NEW WATER TECH Pool Blaster Catfish Pool Spa Cleaner $76.99 Time Remaining: 19d 22h 27m Buy It Now for only: $76.99 |
 HAYWARD AQUA TROL AQ TROL RJ Salt Chlorine Generator $421.95 Time Remaining: 10h 4m |
 ZODIAC JANDY R0452500 Salt Flow Temperature Salinity Sensor Chlorine Generator $169.95 Time Remaining: 24d 9h 31m Buy It Now for only: $169.95 |
 WATER TECH Pool Blaster Catfish Swimming Pool Spa Intex Cleaner Battery Vacuum $75.99 (1 Bid) Time Remaining: 10h 33m |
 INTEX 1600 GPH Krystal Clear Sand Filter Pool Pump Saltwater System $329.00 Time Remaining: 18d 37m Buy It Now for only: $329.00 |
 720 CELLS NEW Seedling Starter Trays +5 PLANT LABELS Easy Out Seed Sowing Flats $12.15 Time Remaining: 21d 10h 34m Buy It Now for only: $12.15 |
 2 WATER TECH Pool Blaster Catfish Swimming Pool Spa Intex Cleaner Battery Vacuum $143.95 Time Remaining: 10h 50m |
 INTEX 2500 GPH Filter Pump Krystal Clear Saltwater System Pool Chlorinator $259.00 Time Remaining: 18d 15m Buy It Now for only: $259.00 |
 2 HYDROFARM CK64060 Germination Hot House with Heat Mat Hydroponic Flower Grow $66.95 Time Remaining: 9h 58m |
 INTEX 1500 GPH Filter Pump Krystal Clear Saltwater System Pool Chlorinator $219.00 Time Remaining: 18d 24m Buy It Now for only: $219.00 |
 Blue Wave NA4155 Swimming Pool Solar Cleaner Ionizer $258.95 Time Remaining: 10h 3m |
 INTEX 2650 GPH Saltwater System Sand Filter Pump Set $439.00 Time Remaining: 19d 1h 53m Buy It Now for only: $439.00 |
 First up EZ 10ft X 10 foot Gazebo Canopy UV Protection Tent Top Cover only $55.99 Time Remaining: 6d 6h 42m Buy It Now for only: $55.99 |
 NEW Unsinkable Aqua Hammock Swimming Pool Floats Blue $83.95 Time Remaining: 11h 46m |
 NEW Plastic Nursery PLANT POTS 36 qty lot +5 FREE SEED LABELS Green containers $4.25 Time Remaining: 9d 9h 37m Buy It Now for only: $4.25 |
 Unsinkable Swimming Pool Cool Wave Comfort Float Blue $98.95 Time Remaining: 13h 13m |
 Seedling starter trays easy out seed flat 720 CELLS NEW $12.15 Time Remaining: 14d 7h 43m Buy It Now for only: $12.15 |
 HYDROFARM Jump Start w Hot House Digital Thermostat $119.95 Time Remaining: 12h 11m |
 ORGANIC WHEAT GRASS 6000 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.25 Time Remaining: 29d 9h 28m Buy It Now for only: $3.25 |
 New Water Tech Aqua Broom Swimming Pool Spa Suction Cleaner Battery Vacuum $43.70 Time Remaining: 11d 8h 27m Buy It Now for only: $43.70 |
 ZODIAC JANDY R0452500 Salt Flow Temperature Salinity Sensor Chlorine Generator $168.95 Time Remaining: 3d 11h 21m Buy It Now for only: $186.95 |
 Propane Torch 31 Inches Fits Any 14 Oz Propane Tank NEW Handy Household Tool $24.95 Time Remaining: 18d 5h 54m Buy It Now for only: $24.95 |
 Moose Bird Feeder Garden Statue Yard Art Lantern NEW A6911 $21.95 (1 Bid) Time Remaining: 3d 5h 2m |
 ZODIAC JANDY R0403700 Salt Flow Temperature Salinity Sensor Chlorine Generator $157.95 Time Remaining: 24d 9h 40m Buy It Now for only: $157.95 |
 INTEX 2000 GPH Swim Pool Pump Saltwater Chlorinator $298.00 Time Remaining: 7d 13h 7m Buy It Now for only: $298.00 |
 ZODIAC JANDY R0452500 Salt Flow Temperature Salinity Sensor Chlorine Generator $168.95 Time Remaining: 5d 9h 35m Buy It Now for only: $186.95 |
 ZODIAC JANDY R0403800 Salt Flow Temperature Salinity Sensor Chlorine Generator $169.95 Time Remaining: 24d 9h 10m Buy It Now for only: $169.95 |
 New WaterTech Pool Blaster Swimming Pool Spa SpaVac Battery Operated Vaccum Tub $38.95 Time Remaining: 5d 11h 36m Buy It Now for only: $43.95 |
 ORGANIC WHEAT GRASS 4400 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.50 Time Remaining: 29d 9h 32m Buy It Now for only: $2.50 |
 2 WATER TECH Pool Blaster Catfish Swimming Pool Spa Intex Cleaner Battery Vacuum $143.95 Time Remaining: 5d 13h 11m Buy It Now for only: $159.95 |
 JANDY PLC1400 AquaPure Salt Chlorine Generator Replacement Cell + Sensor Kit $579.95 Time Remaining: 16d 23h 3m Buy It Now for only: $579.95 |
 HYDROFARM CK64060 Germination Hot House with Heat Mat $36.92 Time Remaining: 3d 22h 32m Buy It Now for only: $36.92 |
 INTEX 1600 GPH Krystal Clear Sand Filter Pool Pump Saltwater System $328.00 Time Remaining: 6d 9h 33m Buy It Now for only: $361.95 |
 INTEX 530 GPH Filter Pump Krystal Clear Saltwater System Pool Chlorinator $199.00 Time Remaining: 15d 7h 55m Buy It Now for only: $199.00 |
 INTEX 2000 GPH GFCI Saltwater Chlorinator Swimming Pool Pump 6 Type B Filters $298.00 Time Remaining: 6d 11h 2m Buy It Now for only: $328.95 |
 INTEX 2000 GPH Saltwater Chlorinator Swimming Pool Pump 6 Type B Filters $309.00 Time Remaining: 22d 23h 1m Buy It Now for only: $309.00 |
 INTEX 2500 GPH Filter Pump Krystal Clear Saltwater System Pool Chlorinator $258.00 Time Remaining: 6d 12h 32m Buy It Now for only: $284.95 |
 INTEX 2000 GPH Swim Pool Pump Saltwater Chlorinator with GFCI 54611EG $298.00 Time Remaining: 3h 8m Buy It Now for only: $298.00 |
 NEW HAYWARD GOLDLINE T CELL 9 Turbo Cell Salt Chlorine $370.00 Time Remaining: 5h 53m Buy It Now for only: $370.00 |
 HAYWARD AQUA TROL AQ TROL RJ Salt Chlorine Generator $421.95 Time Remaining: 6d 11h 12m Buy It Now for only: $465.95 |
 GOLDLINE HAYWARD TCELL3 Aquarite Turbo Cell Chlorinator $209.00 Time Remaining: 4d 23h 33m Buy It Now for only: $209.00 |
 New WaterTech Pool Blaster Swimming Pool Spa SpaVac Battery Operated Vaccum Tub $38.95 Time Remaining: 6d 13h 11m Buy It Now for only: $43.95 |
 Mason Canning Fruit Jar Solar Lid Light In Brown or Silver Finish Country Decor $12.57 Time Remaining: 6d 14h 34m Buy It Now for only: $12.57 |
 HYDROFARM CK64061 Hot House Plus with Heat Mat 6 Dome Hydroponic Seed Flower $42.71 Time Remaining: 5d 13h 16m Buy It Now for only: $48.95 |
 INTEX 1000 GPH Filter Pump Krystal Clear Saltwater System Pool Chlorinator $198.00 Time Remaining: 18d 8m Buy It Now for only: $198.00 |
 New WaterTech Pool Blaster Swimming Pool Spa SpaVac Battery Operated Vaccum Tub $39.95 Time Remaining: 12d 5h 24m Buy It Now for only: $39.95 |
 ORGANIC WHEAT GRASS 6800 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.25 Time Remaining: 1d 6h 20m Buy It Now for only: $3.60 |
 NEW Unsinkable Aqua Hammock Swimming Pool Floats Blue $84.95 Time Remaining: 17d 7h 18m Buy It Now for only: $84.95 |
 ORGANIC WHEAT GRASS 6000 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.00 Time Remaining: 1d 6h 20m Buy It Now for only: $3.30 |
 NEW Unsinkable Sport Swimming Pool Float Blue $64.95 Time Remaining: 10d 8h 39m Buy It Now for only: $64.95 |
 Kelsyus Floating Lounger Pool Float Lounge Chair NEW $47.22 Time Remaining: 29d 6h 21m Buy It Now for only: $47.22 |
 ORGANIC WHEAT GRASS 5200 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.50 Time Remaining: 1d 6h 21m Buy It Now for only: $2.75 |
 Fascinations Green Science Solar Flier Sun Powered Flying Airplane $27.95 Time Remaining: 24d 10h 9m Buy It Now for only: $27.95 |
 ORGANIC WHEAT GRASS 4400 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.25 Time Remaining: 1d 6h 22m Buy It Now for only: $2.50 |
 INTEX 1200 GPH Krystal Clear Sand Filter Pool Pump Saltwater Chlorniator $299.00 Time Remaining: 18d 40m Buy It Now for only: $299.00 |
 New Water Tech Aqua Broom Swimming Pool Spa Suction Cleaner Battery Vacuum $42.70 Time Remaining: 6d 10h 54m Buy It Now for only: $48.95 |
 INTEX 1000 GPH Filter Pump Krystal Clear Saltwater Pool Chlorinator w GFCI $199.00 Time Remaining: 18d 12m Buy It Now for only: $199.00 |
 INTEX 1000 GPH Filter Pump Krystal Clear Saltwater Pool Chlorinator w GFCI $198.00 Time Remaining: 18d 10m Buy It Now for only: $198.00 |
 ORGANIC WHEAT GRASS 6800 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.25 Time Remaining: 3d 7h 48m Buy It Now for only: $3.60 |
 3x5 trays Bedding Plant SEED STARTER 24 qty +5 LABELS EASY OUT Seedling insert $4.00 Time Remaining: 10d 14h 36m Buy It Now for only: $4.00 |
 ORGANIC WHEAT GRASS 6000 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.00 Time Remaining: 3d 7h 49m Buy It Now for only: $3.30 |
 Moose Bird Feeder Garden Statue Yard Art Lantern NEW A6911 $19.75 Time Remaining: 2d 7h 54m Buy It Now for only: $19.75 |
 ORGANIC WHEAT GRASS 4400 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.25 Time Remaining: 3d 7h 51m Buy It Now for only: $2.50 |
 ORGANIC WHEAT GRASS 6800 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.50 Time Remaining: 29d 9h 26m Buy It Now for only: $3.50 |
 ORGANIC WHEAT GRASS 5200 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.75 Time Remaining: 29d 9h 31m Buy It Now for only: $2.75 |
 ORGANIC WHEAT GRASS 5200 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.50 Time Remaining: 3d 7h 50m Buy It Now for only: $2.75 |
 INTEX 2500 GPH Filter Pump Krystal Clear Saltwater Pool Chlorinator w GFCI $259.00 Time Remaining: 18d 28m Buy It Now for only: $259.00 |
 ORGANIC WHEAT GRASS 6800 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.25 Time Remaining: 6d 9h 21m Buy It Now for only: $3.60 |
 disposable gloves 50 ct New Disposable Gloves 50 FreeSh $7.95 Time Remaining: 27d 23h 41m Buy It Now for only: $7.95 |
 ORGANIC WHEAT GRASS 6000 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $3.00 Time Remaining: 6d 9h 23m Buy It Now for only: $3.30 |
 Seedling seed starter flat 3x5 tray 120 trays GROW $12.15 Time Remaining: 18d 8h 25m Buy It Now for only: $12.15 |
 Mason Jar Solar Lid Light Led Set Lot Patio Pathway NEW $49.78 Time Remaining: 13d 14h 10m Buy It Now for only: $49.78 |
 ORGANIC WHEAT GRASS 5200 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.50 Time Remaining: 6d 9h 23m Buy It Now for only: $2.75 |
 Solar Pest Killer W Stake Outdoor Garden Yard Decor NEW E6143 $18.95 Time Remaining: 9d 8h 37m Buy It Now for only: $18.95 |
 ORGANIC WHEAT GRASS 4400 SEEDS HUMAN CAT RABBIT DOG BIRD TURTLE ANY PET ANIMAL $2.25 Time Remaining: 6d 9h 23m Buy It Now for only: $2.50 |
 Unsinkable Swimming Pool Cool Wave Comfort Float Blue $99.95 Time Remaining: 10d 8h 15m Buy It Now for only: $99.95 |
in excel, how would I write a formula that states if tab 2 cell a2 > 40 than no , and the same for yes. ?
I have an excel spreadsheet that I use for a schedule. I want to add a part that by each persons name states if they are scheduled over time or not. So basically I want to state that if someone has more than 40 hours a week, it comes back yes, if less then 40, comes back no. These are all on different tabs. one tab for where I want to have the over time information and one tab for a labor analysiswhere their total hours are listed
Use MATCH and INDEX to reference the person's name. Then use a simple IF statement to check for hours.
So, for example:
If your main Hours sheet is Sheet2 and the names are listed in A1 thru A40 (on both sheets), and hours in B1 thru B40 (on both sheets)
put the following formula in B1 and copy down to B40.
=IF(INDEX(Sheet2!B$1:B$40,MATCH(A1, Sheet2!A$1:A$40,0))>40,"yes", "no")
