Help about If

P

Pietro

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)
 
P

pinmaster

Hi,

Try:

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

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

HTH
Jean-Guy
 
D

Don Guillett

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