9th February 2005, 12:54 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by xptdriver
Gday gurus,
thanks for that... but i must be slightly retarded (or maybe severely). But the way I read that, I still have to do each cell individually.. I tried it and cant run down a column and only get rid of the errors.. all the data goes.. I must be doing something very very wrong..  Unless I have totally misunderstood you blokes |
It depends on how you've done your formatting, but say for instance that your prices are appearing in column D, which are the results of calcs in columns A B & C, then what you can do as an option is in column E write the following formula:
If(d1="","",d1) etc in all the cells where you want the prices to be shown. column D then can be hidden so that you only ever see the final outcomes in column E - if that makes sense. There should be no need to continually run down a column to get rid of the errors unless you are using macros or VBA code that is overwriting the column in which your prices are being shown.
I generate prices of this nature every day and never have a problem re nil entry cells.
|