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

Adjust to suit your needs


"talltom" wrote:

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!!