Thread: IF(OR FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renee Renee is offline
external usenet poster
 
Posts: 73
Default IF(OR FUNCTION

The following formula works okay for me, but I want o expand the statement to
include two more names, ie. I want the same results that I get when "DUNN"
is entered for "JANE" and "THOMPSON". How can I connect them?

=IF(OR(D14,D15="DUNN")*AND(D10,D11="DUNN"),"VIOLAT ION!","")

Any help is appreciated.

Renee