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

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