Need help with multiple IF functions...

[soltek]

OK here it is. I have a sheet with various info of dates, part numbers
of stock, and number of days from Sales order entered to ship date.
I have about 15 or so part numbers like BS1101 or BS1401. If the part
number is one of these, entered in one column, I would like another
column to display an "S" for server. If they are not one of these part
numbers, I would like for it to disply a "D" for desktop.

A B

BS1101 S
BS1505 D

 

[Frank Kabel]

Hi
if your relevant part numbers for servers are in the range
X1:X20 use the following formula in b1:
=IF(COUNTIF(X1:X20,A1),"S","D")
and copy down

 

[Bernie Deitrick]

Soltek,

You need to set up a range with your 15 or so part numbers, then use a
formula like

=IF(ISERROR(MATCH(A2,Range with the list,False)),"D","S")

where A2 is the cell with your part number of interest. Note that you
should use absolute references when entering the range with the list, like
$C$1:$C$15, for copying ease.

HTH,
Bernie
MS Excel MVP

 

[Helen]

Highlight the 15 partnumbers and name them. In the
example below I have called them "range"

In cell b2 enter =if(isnumber(match(a2,range,0)),"S","D")
and drag the formula down.

Best Regards

 

[soltek]

Helen, you win the door prize. Big ups, it works great.

One more if no one minds. Considering the prior, The number of days i
takes for the order placed, to the ship date, is in one column. Ou
goal is 3 days for desktops and 5 for servers, max. Is it possible i
this column to conditional format overages for each to a differen
background color? Thanks much in advanced

 

[soltek]

Helen, you win the door prize. Big ups, it works great.

One more if no one minds. Considering the prior, The number of days i
takes for the order placed, to the ship date, is in one column. Ou
goal is 3 days for desktops and 5 for servers, max. Is it possible i
this column to conditional format overages for each to a differen
background color? Thanks much in advanced