Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical text checking of a cell
I'm trying to prepare a simple sheet to be used as a schedule for a
department store. This store must close with at lease 5 people on staff. I'm attempting to create a cell that checks all the employee times for the day and tell me if there are enough people scheduled for the store close that day. The same person makes the schedule every week, and always types them like this "6:30-9" with 9 being a closing schedule. I'd like to develop a formula that will check a cell for a value of "XXXXX-9" where the X's can be wildcards. All I want is the formula to look at the last 2 characters of the cell and determine if they are a "-9" and return a TRUE/FALSE result. The second thing I'd like to do is to check a column for all these TRUE/FALSE results and determine if there are equal/greater than 5. I was asked by a friend to look into this because I have minor experience in excel formulas, but this is way beyond my ability. All he knows is how to punch numbers in a cell and make them pretty colors :) All your help is appreciated in advance! Chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical test of text? | Excel Worksheet Functions | |||
Stop error checking a cell that has been formatted to text | Excel Discussion (Misc queries) | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Check if text exists within a cell range and return logical vaule - possible? | Excel Discussion (Misc queries) | |||
Logical Text Formula | Excel Worksheet Functions |