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