IF problem.....

T

tom300181

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
 
M

mangesh_yadav

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

Mangesh
 
T

tom300181

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

Thanks

To
 
M

mangesh_yadav

Becasue of
A - Code (801,802, 803, 0, " ")
Click to expand...

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
 
P

paul

" " 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??
 
Top