IF Logical Test

How can I write a formula that in effect goes =IF(cell# contains character
a,b,c,f) then insert contents of cell# here, if not then 0)

Not enough specific info. Maybe something like this:

=IF(OR(A1={"a","b","c","f"}),B1,0)

--
Biff
Microsoft Excel MVP


"s bruce" s wrote in message
...
How can I write a formula that in effect goes =IF(cell# contains character
a,b,c,f) then insert contents of cell# here, if not then 0)

"T. Valko" wrote:

Not enough specific info. Maybe something like this:

=IF(OR(A1={"a","b","c","f"}),B1,0)

--
Biff
Microsoft Excel MVP


"s bruce" s wrote in message
...
How can I write a formula that in effect goes =IF(cell# contains character
a,b,c,f) then insert contents of cell# here, if not then 0)


I have three columns, a,b,c doesn't matter how many rows... many
in cell a1 I enter a alphanumeric a,b,c to designate a downtime code, in
cell b1 I enter the number of minutes of downtime... in cell c1 I want the
formula to check cell a1 and if the alpha is one of a defined list
(a,b,c,f,t,x,z) then I want the contents of cell b1 displayed in cell c1. if
the alpha is anything other than those specified, I want either no entry or a
zero. At the bottom of the colums b1 and c1, I have a sum equation to sum
the contents of the cells in that colum.
So I need to know how to get thos minutes in the c column, IF they are
identified in column a as being of the select group.

Hopefully that makes sense...

Ok, what I suggested will do what you want just add the additional
variables:

=IF(OR(A1={"a","b","c","f","t","x","z"}),B1,0)


--
Biff
Microsoft Excel MVP


"s bruce" wrote in message
...


"T. Valko" wrote:

Not enough specific info. Maybe something like this:

=IF(OR(A1={"a","b","c","f"}),B1,0)

--
Biff
Microsoft Excel MVP


"s bruce" s wrote in message
...
How can I write a formula that in effect goes =IF(cell# contains
character
a,b,c,f) then insert contents of cell# here, if not then 0)


I have three columns, a,b,c doesn't matter how many rows... many
in cell a1 I enter a alphanumeric a,b,c to designate a downtime code, in
cell b1 I enter the number of minutes of downtime... in cell c1 I want
the
formula to check cell a1 and if the alpha is one of a defined list
(a,b,c,f,t,x,z) then I want the contents of cell b1 displayed in cell c1.
if
the alpha is anything other than those specified, I want either no entry
or a
zero. At the bottom of the colums b1 and c1, I have a sum equation to sum
the contents of the cells in that colum.
So I need to know how to get thos minutes in the c column, IF they are
identified in column a as being of the select group.

Hopefully that makes sense...

You were right... it worked great

Thanks

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"s bruce" wrote in message
...
You were right... it worked great

Thanks