Accept or Reject a value

C

crabflinger

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?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top