trying to write a formula ivolving data validation

Sorry mangesh, I still have a couple of questions if thats o.k

Firstly I'm using a simple formula to copy the contents of 1 cell into
another cell on a different worksheet, this is in regards to the time.
Is there anyway that I can write that ormula so that it only shows the
contents if there is an actual time written into the cell ?

Also, with the last formula that you gave me in regards to the food and
beverage, I'm using that over 3 cells now but when i select something
from my lists in 2 cells the 3rd cell which has nothing selected is
showing a value of $0.00, is there any other way around this ??


--
melben
------------------------------------------------------------------------
melben's Profile: http://www.excelforum.com/member.php...o&userid=23619
View this thread: http://www.excelforum.com/showthread...hreadid=373824

Hi Melben,

no problem.

Firstly I'm using a simple formula to copy the contents of 1 cell into
another cell on a different worksheet, this is in regards to the time.
Is there anyway that I can write that ormula so that it only shows the
contents if there is an actual time written into the cell ?

I don't think there is, because time is basically a number and excel
cannot differentiate between two numbers whether it is a time or a
simple number.


Also, with the last formula that you gave me in regards to the food and
beverage, I'm using that over 3 cells now but when i select something
from my lists in 2 cells the 3rd cell which has nothing selected is
showing a value of $0.00, is there any other way around this ??

Can you give your sample data with expected answer and cases.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373824