ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/177733-n.html)

Richard

#N/A

I've got two formulas that display the #N/A when there is no data input. How
can I get rid of this and show nothing.
=Ceiling(B3/E3/F3*G3,3) and =VLOOKUP(A3,Part_Number,3,False)
Thanks in Advance!!

Ron Rosenfeld

#N/A

On Sun, 24 Feb 2008 12:47:00 -0800, Richard
wrote:

I've got two formulas that display the #N/A when there is no data input. How
can I get rid of this and show nothing.
=Ceiling(B3/E3/F3*G3,3) and =VLOOKUP(A3,Part_Number,3,False)
Thanks in Advance!!

=IF(ISNA(your_formula),"",your_formula)

OR

Use Format/Conditional Formatting
Formula Is: =ISNA(cell_ref)
Format the font color to the same as the background color (e.g. white)
--ron

All times are GMT +1. The time now is 09:08 AM.