View Single Post
  #1   Report Post  
Wazza
 
Posts: n/a
Default Help with IF calculation


The 3 is in cell b64 and the last 0.95 is in cell c82, the formula is
the same as yours above accept with the different cell values I will
paste it here ---- :) =IF(J12<3,"",VLOOKUP(J12,$B$64:$C$82,2))




3 0.52
4 0.62
5 0.67
6 0.72
7 0.75
8 0.78
9 0.81
10 0.83
11 0.83
12 0.83
13 0.83
14 0.83
15 0.90
16 0.90
17 0.90
18 0.90
19 0.90
20 0.95
21 0.95


--
Wazza
------------------------------------------------------------------------
Wazza's Profile: http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202