DECISION

[Fernando Duran]

my worksheet 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 sheet, according to transport
criteria, if it's post, has to go to look for freight at that sheet,
etc... can I put it his way...
=IF(E6="POST",SHEET1!E5),IF(E6="UPS",SHEET2!E5)???

 

[JE McGimpsey]

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))

 

[Fernando Duran]

Thanxs
One more .. I put an object before, that I want to remove from the
worsheet, seems that doesn't select to cut it.. why?

 

[Fernando Duran]

I forgot, that in that cell, I already have this formula, beside the
other one.. this is one citeria, then I have the other.... doing this
but programm looks easy, but in a formula in excel, i found it
complicated....may be it's a solution??

=IF(C7 < "H0A",'Canpar Rates'!$L$9,IF(C7 >"H9X",'Canpar
Rates'!$L$9,""))

 

[Fernando Duran]

I explored that option before, but tables are differents, postal codes
are not the same, I used the Vlookup function in each table and I
paste the result in a calculation table,where I add insurance, etc,
then I take the result, and from there goes into the main worksheet,
the user doesn't see the calculations....