Create a table with your "exception" companies, giving Company name and
period; in my exaple below, table is columnsEF, rows 1 to 4. This allows you
to easily extend for new "exceptions".

In column C:

=IF(ISERROR(VLOOKUP(A1,$E$1:$F$4,2,0)),B1+30,B1+VL OOKUP(A1,$E$1:$F$4,2,0))

HTH

"Outbacker" wrote:

im trying to write a formula based on contents of column A. there are five
criteria. a container must be retrieved 30 days after a drop-off date. there
are four exceptions. for two companies, its the drop-off date plus 3 days.
for two other companies, its the drop-off plus 5 days. for all other
companies, its the drop-off date plus 30 days. the company names are in
column A. the drop-off date is in column B. the formula i wrote that adds the
correct day count for a specific 30 day company is as follows:
=IF(a15="macys",B15+30)
i though i could nest 7 criteria but its not working. any help would be
appreciated. i need to add the second company that gets 30 days and the two
companies that get 3 days each from drop-off date. then the final criteria:
all other companies that dont meet the 3 day and 30 day criteria get just
column b date+5 days.
thanks in advance.