Need help with multiple IF functions...

  • Thread starter Thread starter soltek
  • Start date Start date
S

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top