View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KR KR is offline
external usenet poster
 
Posts: 24
Default Can something like this be accomplished?

I have a workbook with two sheets.

Sheet 2 has data like:
pt R5 R6 R7 R8 R9
010 76.0 58.1 51.3 45.8 37.5
020 81.9 61.9 54.7 49.3 44.1
030 95.0 90.0 87.5 85.0 82.9
040 70.2 57.3 51.0 45.8 41.6
etc....................

Sheet 1 contains for example a pt of 020 and a factor of 60.0. Is there
anyway to pull the R value the would be either , < or = the factor in the
row of 020? Say for example the factor of 60.0 in this case would return a R
value of "<R6".

TIA
--
kr