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
--
andyell
------------------------------------------------------------------------
andyell's Profile:
http://www.excelforum.com/member.php...o&userid=35272
View this thread:
http://www.excelforum.com/showthread...hreadid=561424