Help about If
 

Hi all,
Could anybody help me to complete the last part of the following code (the
one written as capital):

=IF(OR(E:E="PETER",E:E="Ramzy",E:E="Michael",E:E=" Mona",E:E="Marianne")*AND(N:N<"Ok"),NOW(),NO CHANGE IN THE VALUE)

I need some help to do the following:
=IF(B:B<NULL VALUE,"Ok",NULL VALUE)

Help about If
 

Hi,

Try:

=IF(AND(N1="OK",OR(E1="PETER",E1="Ramzy",E1="Micha el",E1="Mona",E1=
"Marianne")),NOW(),0)

=IF(B1<0,"OK",0)
or
=IF(B1<"","OK","")

HTH
Jean-Guy

"Pietro" wrote:

Hi all,
Could anybody help me to complete the last part of the following code (the
one written as capital):

=IF(OR(E:E="PETER",E:E="Ramzy",E:E="Michael",E:E=" Mona",E:E="Marianne")*AND(N:N<"Ok"),NOW(),NO CHANGE IN THE VALUE)

I need some help to do the following:
=IF(B:B<NULL VALUE,"Ok",NULL VALUE)

Help about If
 

How about some detail on what are you trying to do? This won't work for
several reasons.

--
Don Guillett
SalesAid Software

"Pietro" wrote in message
...
Hi all,
Could anybody help me to complete the last part of the following code (the
one written as capital):

=IF(OR(E:E="PETER",E:E="Ramzy",E:E="Michael",E:E=" Mona",E:E="Marianne")*AND(N:N<"Ok"),NOW(),NO
CHANGE IN THE VALUE)

I need some help to do the following:
=IF(B:B<NULL VALUE,"Ok",NULL VALUE)