avoiding N/A's

[OZ_exceller]

I am really new at this.

Can someone tell me how to do this:

I got column A & B with formulas using cells from Column C onwards.

My aim is to keep A & B constant as on month basis, I have to dump new data and format the data in Column C onwards.

Formula in A & B gives #NA because of the formating.

Anyway of avoiding this.

Hope I am clear

Thanks in advance

[SamuelT]

Hi,

If I understand your question correctly, you want to clean up the cells with errors in them. An effective way to do this would be to display a blank cell when there is an #N/A error. If so, you can do the following:

=IF(ISERROR(C1),"",your formula here)

If this isn't what you trying to achieve let me know.

HTH,

SamuelT

[OZ_exceller]

Thanks SamuelT.