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

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

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

=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

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

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

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

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