Returning an empty cell when no data present
I know there have been a couple of previous answers to this, but I cannot
seem to make them apply to my situation. I have 2 columns, the 1st pulling
info from another sheet and the 2nd one a calculation using the value of the
first. I am now returning errors in each of these cells because there is no
data present until I enter it. (The spreadsheet is a test-time sheet which
starts out each week empty. Here are my formulas:
=VLOOKUP(A4,Prod_and_Rte,2,FALSE)
=(E4*F4)/C4
Can someone help me return empty cells when no data is present, please?
Thanks,
Bryan
|