View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
crabflinger crabflinger is offline
external usenet poster
 
Posts: 7
Default Accept or Reject a value

Im trying to set up a spreadsheet that will indicate whether or not a value
is acceptable or rejectable based on a given value. In example.... say that
a certain value needs to be between 3.0 and 5.0..... if the value is 2.9 or
below / 5.1 or above, it will automatically fill in a seperate cell with an
"X". And if the value falls between 3.0 and 5.0 it will fill in a different
cell with a "check mark".

I was able to accomplish this, however it was several years ago and I dont
have the first clue as to how I go about this.

Can anyone please help?????