Thread: IF statements referencing an absolute value or a range of values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 2,118
Default IF statements referencing an absolute value or a range of values
Try this:

If A1 contains the number to test

Then...
B1: =IF(ABS(A1)<=5,"OK","Validation Error!")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"skaminski" wrote:

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