IF Logical Test

  • Thread starter Thread starter s bruce
  • Start date Start date
S

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)
 
Not enough specific info. Maybe something like this:

=IF(OR(A1={"a","b","c","f"}),B1,0)
 
T. Valko said:
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
Click to expand...
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)
 
Back
Top