Complicated IF Formula

Luke,
I am not really sure what you are looking for here, but the one thing
that is certainly not going to work in your formulas is comparison of
text and numbers. Use VALUE(RIGHT(...))<=whatever if you want to
compare the numeric value of a portion of text with another cell that
has numeric content.

HTH
Kostis Vezerides

Yes I understand and I do use it but perhaps I was not clear enough. see my
response post to Niek Otten.
Luke

"vezerid" wrote:

> Luke,
> I am not really sure what you are looking for here, but the one thing
> that is certainly not going to work in your formulas is comparison of
> text and numbers. Use VALUE(RIGHT(...))<=whatever if you want to
> compare the numeric value of a portion of text with another cell that
> has numeric content.
>
> HTH
> Kostis Vezerides
>
>