View Single Post
  #3   Report Post  
vezerid
 
Posts: n/a
Default 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