IF Logical Test

[s bruce]

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]

Not enough specific info. Maybe something like this:

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

 

[s bruce]

Not enough specific info. Maybe something like this:

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

--
Biff
Microsoft Excel MVP





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...

 

[T. Valko]

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)

 

[s bruce]

You were right... it worked great

Thanks

 

[T. Valko]

You're welcome. Thanks for the feedback!