Thread: Help about If
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default 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)