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

Hi Wazza

just another note, you don't need to put all the values in (the ones above
10 i mean)... using VLOOKUP with a sorted list and no fourth parameter
specified will do what i think you're after without having to have all the
numbers there. But at the moment, this is of secondary concern.

Cheers
JulieD

"Wazza" wrote in message
...

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