Thread: IF statements referencing an absolute value or a range of values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default IF statements referencing an absolute value or a range of values
Look in the help index for AND and IF

--
Don Guillett
SalesAid Software

"skaminski" wrote in message
...
Does anyone know how to create a conditional statement for the following
situation?

If the value in a particular cell is between -5 and 5, then return a
message
that says "ok", otherwise return a message that says "validation error".


Reply With QuoteReply With Quote