hiding blank cells when no results

A

andyell

I have a spreadsheet to use as a `pricing template i have pre filled the
first 60 lines with the formulae needed b ut until there are entries
made into the first 3 columns the rest of ht ecolumns show #N/A or
#REF!


i have tried to hide them using =if(a3=" "," ",rest of formula

:confused:

Any Ideas?

Andy
 
R

Richard Buttrey

I have a spreadsheet to use as a `pricing template i have pre filled the
first 60 lines with the formulae needed b ut until there are entries
made into the first 3 columns the rest of ht ecolumns show #N/A or
#REF!


i have tried to hide them using =if(a3=" "," ",rest of formula

:confused:

Any Ideas?

Andy
Click to expand...

=if(Iserror(yourfunction),"",yourfunction)

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
M

Max

andyell said:
.. i have tried to hide them using =if(a3=" "," ",rest of formula
Click to expand...

Think you were quite close in your attempt, just try it as:
=if(A3="","",rest of formula)
 
Top