what if

B

Big Chris

You can't - have you tried nesting formulae to reduce the amount of
'IF's required? i.e. =IF(OR(a1=1,a1=2,a1=3),"yes","No").

It really depends on what you're trying to do and the output that you
require, but usually just means a bit of lateral thinking.
 
B

Bob Phillips

Tell us what you are trying to do, there are various options.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
B

Big Chris

You can't - have you tried nesting formulae to reduce the amount of
'IF's required? i.e. =IF(OR(a1=1,a1=2,a1=3),"yes","No").

It really depends on what you're trying to do and the output that you
require, but usually just means a bit of lateral thinking.
 
M

mikey

i am working on a cost sheet for 12 products , to manufacture a product

u require 2 raw materials , based on the product choice the raw
material is
is directly shown .
 
M

mikey

Bob said:
Tell us what you are trying to do, there are various options.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...


i am working on a cost sheet for 12 products , to manufacture a product

u require 2 raw materials , based on the product choice the raw
material is
is directly shown .
 
V

vezerid

You probably need VLOOKUP(). How you use it depends on how your data is
organized. Check the online help and return if you need additional
help, explaining the structure of your data.

HTH
Kostis Vezerides
 
Top