I have got a sheet that has 3 columns.

A - Code (801,802, 803, 0, " ")
B - Time (14:00:01... )
C - formula

I want C to look @ A establish which code is present and if 801/2/3 etc
return time from B. However, if code is 0 I want C to return time from
B but the issue arrises if A has a space it returns the time from B.

How can I get it to return a space/- if col A is a space and not a
code.

Thanks


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=380011

=IF(A1=" ","",your_formula_here)

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=380011

Thios does not appear to work. Anyone got any ideas?

Thanks

Tom


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=380011

can you post your current formula, also what do you mean by space, is it
" " or "". Try both.

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=380011

By space I mean an empty cell....... Apologies for any
misunderstandings...

Thanks

Tom


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=380011

Becasue of

A - Code (801,802, 803, 0, " ")

I gave the formula:
=IF(A1=" ","",your_formula_here)

Change it to:
=IF(A1="","",your_formula_here)

What this does is, check if cell A1 is blank, if so, it puts the "" in
the result cell, else, your_original_formula

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=380011

Hi, is this suit yr purpose?

IF(A1 < "", B1, "")

regards


--
swchee
------------------------------------------------------------------------
swchee's Profile: http://www.excelforum.com/member.php...o&userid=24279
View this thread: http://www.excelforum.com/showthread...hreadid=380011

" " is a space "" is blank.If " " doesnt work then you have more than one
space in there,or do you have some other characters with a space between??
--
paul
remove nospam for email addy!



"tom300181" wrote:


Thios does not appear to work. Anyone got any ideas?

Thanks

Tom


--
tom300181
------------------------------------------------------------------------
tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
View this thread: http://www.excelforum.com/showthread...hreadid=380011