[AccessD] Function in excel

You could try

=if(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)))))),0)


Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: 28 June 2009 14:50
To: Access Developers discussion and problem solving
Subject: [AccessD] Function in excel

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 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com