View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haz Haz is offline
external usenet poster
 
Posts: 46
Default IF function help

Hello,
I have data arrange as this,
b2 c2 D2
1 2 3 ........17
B3 C3 D3
0 2 5 ..........15
Using the above criteria i would like to match C2 in col E then
corresponding C3 with col B and if number in Col B is below that of C3 then
return ''out' if over ''on target''

Hope this clear, I have tried this with an IF function but can't get it to
work?

Any help would be appreciated.

Thanks