Re: DECISION

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/02/04 

Date: Tue, 02 Mar 2004 14:15:15 -0700

If you only have the two choices, you can use

   =IF(E6="POST",Sheet1!E5, Sheet2!E5)

If you have more, you can nest IF functions:

    =IF(E6="POST",Sheet1!E5, IF(E6="UPS",Sheet2!E5,Sheet3!E5))

In article <bto9401tpnrt8r45apau36rskhkri91kfl@4ax.com>,
 Fernando Duran <FDURAN1@NETZERO.COM> wrote:

> my work*** is getting bigger, I have to add a new module, that is
> ready, now I have two problems, in a cell I have to tell the program
> to pick the resulte from another ***, according to transport
> criteria, if it's post, has to go to look for freight at that ***,
> etc... can I put it his way...
> =IF(E6="POST",SHEET1!E5),IF(E6="UPS",SHEET2!E5)???

Quantcast