Thread: IF statements referencing an absolute value or a range of values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
skaminski skaminski is offline
external usenet poster
  
Posts: 2
Default IF statements referencing an absolute value or a range of values
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