| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with IF calculation
Julie, I tried both those formulas without success :(, I want them to say if j12 =3 then the cell will show 0.52, using your formula the cell just says #N/A hmmmmmm thanks for your help! -- 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
what is the range of your VLOOKUP table (ie the two column one that starts with 3 (top left) and ends with 0.95 (bottom right)) what is the exact formula you are using (just copy & past it in the reply) Cheers JulieD "Wazza" wrote in message ... Julie, I tried both those formulas without success :(, I want them to say if j12 =3 then the cell will show 0.52, using your formula the cell just says #N/A hmmmmmm thanks for your help! -- 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) | |||
| Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
| Help on automatically ending a calculation | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
