multiple if functions

  • Thread starter Thread starter Dave W
  • Start date Start date
D

Dave W

what am I missing

=IF(OR(cab_type=obc,"OB"&cab_width&"-"&no_of_doors&"-
"&no_of_drawers,cab_type=owc,"W"&cab_width&cab_height&cab_
depth),"")

the object of the formula is to fill in a cell with OB24-
1-1 or W243612 based on the type of cabinet chosen from a
drop down list in another cell.

I hope this makes enough sense

Thanks in advance for any hepl
 
Hi
try
=IF(cab_type=obc,"OB"&cab_width&"-"&no_of_doors&"-"&no_of_drawers,IF(ca
b_type=owc,"W"&cab_width&cab_height&cab_
depth),"")
 
Thanks for looking at this so fast
but excel is still saying I need another "(" some where
but I can fique out where
 
Hi
try
=WENN(cab_type=obc;"OB"&cab_width&"-"&no_of_doors&"-"&no_of_drawers;WEN
N(cab_type=owc;"W"&cab_width&cab_height&cab_depth;""))
 
Thanks that works much better
-----Original Message-----
Hi
try
=WENN(cab_type=obc;"OB"&cab_width&"-"&no_of_doors&"- "&no_of_drawers;WEN
N(cab_type=owc;"W"&cab_width&cab_height&cab_depth;""))

--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
Frank - what function is =WENN? Can't find it anywhere in
the help files. Diffrent version of Excel?
 
German equivalent of IF

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Hi
just forgot to translate it back to English :-) Use
=IF(cab_type=obc,"OB"&cab_width&"-"&no_of_doors&"-"&no_of_drawers,IF(ca
b_type=owc,"W"&cab_width&cab_height&cab_depth,""))

WENN: German for 'IF'
 
Frank - thought that might be the case. Was gonna mention
it but didn't want to assume that cause you live in
Germany, that you spoke German. I live in California, and
no one here speaks English!! Or it seems so to me.

Have a great weekend - which started hours ago for you =
get at it!!
 
Back
Top