[AccessD] Function in excel

Kostas Konstantinidis kost36 at otenet.gr
Sun Jun 28 09:37:06 CDT 2009


Max

I tried the same but with one parenthesis less :-))
just to know that in Greek Office -since version 2000 and then-
is using ";" instead of  ","

thank's a lot
kostas



----- Original Message ----- 
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Sunday, June 28, 2009 5:10 PM
Subject: Re: [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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> 





More information about the AccessD mailing list