#N/A

[Richard]

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]

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