Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sequential numbers with alpha characters help needed
The following is working as it should, but now I need this formula to
recognize work order numbers that have either an "N" preceeding or trailing the 5 digit number, or an "O" preceeding or trailing the 5 digit number. The formula works fine with just numbers.ie (B$99=52000.) =IF($B$7B$99,$D$93,IF(AND(B$17<=B$102,$F$50,$B$2 0<=6),($F$5*$D$103)+$D$94,IF(AND($B$17$B$102,$B$2 0<=6),($B$17*$B$103*$F$5)+$D$95,IF($B$206,($F$5*$ D$96)+$D$94+($B$103*$F$5*$B$17))))) B$99=52000, B$100=N06000, and B$101=O6000 This is what I've tried with no success. =IF(OR($B$7B$100,$B$7B$101,$B$7B$99,$D$93...... ... Thank you in advance!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to alpha code | Excel Discussion (Misc queries) | |||
How do I set rows to Alpha and columns to numbers? | Setting up and Configuration of Excel | |||
How to separate the numbers and characters in the cell | Excel Worksheet Functions | |||
Print sequential page numbers on one worksheet printed multiple ti | Excel Worksheet Functions | |||
Binary Numbers longer than 10 characters | Excel Worksheet Functions |