Question on formulas

  • Thread starter Thread starter Trackkid12
  • Start date Start date
T

Trackkid12

I have a worksheet in which many students have given their answers t
how many pieces of candy are in a jar. I am trying to figure out
formula that will allow me to find out who was right within 10 percen
of the actual number. Like if the actual number was 100 I want to fin
the people who entered numbers from 90-110. I am wondering if their i
an easier way than just typing in all the numbers between 90-110 in
filter.

Thanks
 
assume the numbers are in column B starting in row 2 (B2) and the actual
number is 100

in C2 put in a formula

=if(Abs(B2-100)<=(.10*100),"Within 10%","Exceeds 10%")

then drag fill down the column.

Now you can filter on this column (with the formula).
 
You must log in or register to reply here.

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

Similar Threads

Excel Conditional formula for different scenarios 0
Insert formula and copy to a range of cells above 2
Excel Need Countifs Formula Help 0
Finding a "Min" value 5
Macro to insert formulas on last row of different worksheets 1
Macro to insert formulas in the last row of different worksheets 1
Help creating a sales commission formula 3
match formula needed 2

Back
Top