Re: 2 Formulae 1 Cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


pajodublin Wrote:
> Hi,
> Im trying to use 2 IF functions on the one cell.
>
> My jobs consists of alot of printing with numerous types of paper each
> numbered differently. Jobs that come in are all named differently and
> use different forms. for example. the Job APTFEE uses ASC31 stationary,
> whereas job R30EE uses RCT31 stationary.
>
> Im trying to set up a form so when someone types in the job name the
> type of paper will appear in the cell. I hope im making sense.
>
> this is the formula ive been using, and changing it around for the last
> 4 hours without success...
> =IF(A4="Aptfee","ASC31","False")OR(=IF,A4="r30ee","RCT31","False")
>
> Ive tried alot of different ones this one is just the current one ive
> tried and i probably was closer before, any help would be much
> appreciated
> Thanks
> Pajodublin


Try this ...

=IF(A4=\"APTFEE\",\"ASC31\",IF(A4=\"R30EE\",\"RCT31\",\"FALSE\"))

OR, if there are only 2 choices for A4, i.e, either it is "Aptfee" or
"r30ee" then your formula can be

=IF(A4=\"APTFEE\",\"ASC31\",\"RCT31\")

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=477026

.

Relevant Pages

  • 2 Formulae 1 Cell
    ... Im trying to use 2 IF functions on the one cell. ... My jobs consists of alot of printing with numerous types of paper each ... Pajodublin ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel Formulas
    ... Thanks alot for the tips. ... something from a drop down list in B2 Cell D2 would have the correct answer. ... Department Heads are ... How could I sort out only the Department ...
    (microsoft.public.excel.worksheet.functions)
  • Re: cell phones
    ... > i have noticed that alot of these actors on the soaps are using their cell ... > couldnt use your cell phone. ... Most hospitals now allow mobile phone usage ...
    (rec.arts.tv.soaps.cbs)
  • Re: cell phones
    ... >> i have noticed that alot of these actors on the soaps are using their cell ... >> couldnt use your cell phone. ... > Most hospitals now allow mobile phone usage ... Typically not in patient rooms and not in the ICU. ...
    (rec.arts.tv.soaps.cbs)
  • Re: Splitting up text between two fields
    ... >> (DR, ST, AVE, CIR, RD) to the cell to the right. ... >> a macro I could program to do this? ... I have alot of them ...
    (microsoft.public.excel.programming)