How to make a figure show a value in another cell dependent on what line of text is chosen in an another cell?
Cell A (Sheet1) I have a drop down menu with "Stock" " Sales "Advertising"
The drop down
menu is on sheet2,
in cell B is blank but will have a numerical value added when needed.
three columns C, D, E
C is STock
D is Sales
E is Advertising
If A1 = "stock" and B1 has a value typed in then C1=B1
but if B1 is left blank then C1 should not have anything in it or equal zero
and using the formula underneath C1 contains #VALUE when B1 is left blank or "Advertising" or "Sales" is
selected in A1
This formula does the calculation but #VALUE! appears if "Stock" is not selected,
how can I stop this or equal C1 to 0 if "Stock" is not selected.
I have been racking my brains for
nearly 24 hours and searched many forums please someone put me out of misery and help or at least tell me if I am going about
the whole conundrum the wrong way.
Thanks in advance.