Thread: yes/no - please someone help!!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lacty Lacty is offline
external usenet poster
  
Posts: 14
Default yes/no - please someone help!!


Ola

Try this

=IF( OR(C4 = -50000 , C4< +50000 ), "Investigate" , "Fine" )

Use the OR function deal with the value criteria and if any criteria
is true, the IF Function will return "Investigate"

Reply With QuoteReply With Quote