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

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

Thank you for the help. I am very new to this type of problem. How exactly
do I make this work? I put in place of the RIGHT,"B100" a 5, Then a 6,in
place of the LEN "B100".
When I accept this it gives me a "#VALUE!" ANSWER

The # in B100=N06000, and the # in B101=O06000, B$99=52000 What I need is
for the formula to give me a value depending on which number I put in B7.

Thanks again!

talltom

"Teethless mama" wrote:

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