• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with If,Then,results type formula

G

grashop

New Member
Hi,

I am trying to write a formula to help with auditing material reports. We have chemical ranges set up with a minimum and maximum, then the actual result is entered in another column. When the result is entered I would like to have it show whether the result is in range or not. Example


Carbon Min .05% Max 1.2% Actual result .09% Accept or Reject


I have been trying If,then as well IF, AND but without any luck.


Thanks for your help!!
 
Grashop

try

=if(and(carbon>=min,carbon<=max),"In range","Out of range")

put the cell references in for min, max and carbon as appropriate

change >= to > as you require etc
 
Wow thanks that looks like it is going to work perfectly!! Thank you, Thank you!!!! Saved by the Ninja!!!
 
You must log in or register to reply here.
Back
Top