Hiding formulas

[Dee]

I need to create a spreadsheet that will track Drug shipped to an
investigator's site. Also on this spreadsheet I need to use some calculations
to determine how much drug is being used per subject. My question is, in
Cells d2, e2 and f2 I have vlookups and caculations. Is there a way to copy
the formulas down the column but not have "N/A" or "Name" appear in these
columns because they are caculated when I add informatin to cell C2 etc. I
would like to put the formulas in and have the cells not show anything until
I add my information in column C. Any suggestions would be helpful.

Thanks very much for your help.

Best regards,

Dee

[dtbill21]

You can use something like so:

if(c2<>"",vlookup(...),"")

which will return "" if c2 doesn't have a value


"Dee" wrote:

> I need to create a spreadsheet that will track Drug shipped to an
> investigator's site. Also on this spreadsheet I need to use some calculations
> to determine how much drug is being used per subject. My question is, in
> Cells d2, e2 and f2 I have vlookups and caculations. Is there a way to copy
> the formulas down the column but not have "N/A" or "Name" appear in these
> columns because they are caculated when I add informatin to cell C2 etc. I
> would like to put the formulas in and have the cells not show anything until
> I add my information in column C. Any suggestions would be helpful.
>
> Thanks very much for your help.
>
> Best regards,
>
> Dee
>
>