| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Its a easy dumb question.
When i have formulas with there criteria not fullfilled, i get the "#N/A". How do i get that to go away? -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#2
|
|||
|
|||
|
comotoman Wrote: When i have formulas with there criteria not fullfilled, i get the "#N/A". How do i get that to go away? One way ... =IF(ISERROR(YOUR_FORMULA),\" \",YOUR_FORMULA) will take care of this problem of yours. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#3
|
|||
|
|||
|
you still have an error on your formula...so you know -- MDOTJR IT ------------------------------------------------------------------------ MDOTJR's Profile: http://www.excelforum.com/member.php...o&userid=27332 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#4
|
|||
|
|||
|
=if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE)," ",VLOOKUP(A9,$C$154:$G$680,2,FALSE))) i get an error message base on the " " -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#5
|
|||
|
|||
|
Please Help!!! -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#6
|
|||
|
|||
|
Thats
=IF(ISERROR(VLOOKUP(A9,$C$154:$G$680,2,FALSE)),"", VLOOKUP(A9,$C$154:$G$680,2,FALSE)) "comotoman" wrote in message ... =if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE)," ",VLOOKUP(A9,$C$154:$G$680,2,FALSE))) i get an error message base on the " " -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#7
|
|||
|
|||
|
That did the trick, thank you all for the help! -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
|
#8
|
|||
|
|||
|
Youre welcome,
Alan. "comotoman" wrote in message ... That did the trick, thank you all for the help! -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=468285 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy Formula Question - if you know how! | Excel Discussion (Misc queries) | |||
| Easy VB code question | Excel Discussion (Misc queries) | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Easy formula Question | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
