hiding blank cells when no results

[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



Any Ideas?

Andy

[Richard Buttrey]

On Fri, 14 Jul 2006 07:11:05 -0400, andyell
<[email protected]> wrote:

>
>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
>
>
>
>Any Ideas?
>
>Andy

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

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

[Max]

"andyell" wrote:
> .. i have tried to hide them using =if(a3=" "," ",rest of formula

Think you were quite close in your attempt, just try it as:
=if(A3="","",rest of formula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---