Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
Help on automatically ending a calculation | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |