"talltom" wrote:

The following formula is working as it should, but now I need this formula to
recognize work order numbers that have either a 5 digit number, or 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=O06000

This is what I've tried with no success.
=IF(OR($B$7B$100,$B$7B$101,$B$7B$99,$D$93...... ...

We need the formula to give us an answer based on the number sequence I put
into B7.

Thank you in advance!!

The following was sent to me by teethless mama, but I cant get it to work.

=IF(OR(B7RIGHT(B100,LEN(B100)-1)+0,B7RIGHT(B101,LEN(B101)-1)+0),"your
formula","")

Adjust to suit your needs