Kostas Konstantinidis
kost36 at otenet.gr
Sun Jun 28 08:50:24 CDT 2009
hi all, I use the follow in excel 2007 =IF(A5="p/m";13,5;IF(A5="m/b";13;IF(A5="p/b";14;IF(A5="x/b";13;IF(A5="a";5,5;IF(OR(A5="b";A5="e";A5="z");7;7,5)))))) that works perfect but what I want to add plus in that is to return null or zero in any other case is that possible? many thank's /kostas