# I am trying to create an IF formula with a +/- range!

✭✭✭✭

Hello!

I am trying to create an IF formula where if the value is 40% with a range of +/- 2%, it is a pass. If it is any percentage outside of the range (38%-42%), then I was it be a fail. Here is the chart in reference! Any help would be amazing.

Tags:

• ✭✭✭✭✭✭

Try this

=IF(AND([Rasterized Patch Measurement]@row >= 0.38, [Rasterized Patch Measurement]@row <= 0.42), "Pass", "Fail")

This looks at the value in Rasterized Patch Measurement. If it is more than or equal to 0.38 (which is 38% if you have used the percent format option) AND less than or equal to 0.42 (42%) then it returns "Pass". For all other values it returns "Fail".

• ✭✭✭✭✭✭

You can set up conditional formatting using this option in the tool bar

Click OK

Then set your format

Click OK

Then choose whether to change the whole row or just the cell

Repeat for green.

There is a tutorial here: https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

• ✭✭✭✭✭✭

Try this

=IF(AND([Rasterized Patch Measurement]@row >= 0.38, [Rasterized Patch Measurement]@row <= 0.42), "Pass", "Fail")

This looks at the value in Rasterized Patch Measurement. If it is more than or equal to 0.38 (which is 38% if you have used the percent format option) AND less than or equal to 0.42 (42%) then it returns "Pass". For all other values it returns "Fail".

• ✭✭✭✭

@KPH this worked perfect, thank you so much!

• ✭✭✭✭

@KPH , do you know if I would be able to have the column color change along with the pass/fail? Like the photo below

• ✭✭✭✭✭✭

You can set up conditional formatting using this option in the tool bar

Click OK

Then set your format

Click OK

Then choose whether to change the whole row or just the cell

Repeat for green.

There is a tutorial here: https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

• ✭✭✭✭

@KPH , amazing thank you very much!

• ✭✭✭✭✭✭

Happy to help. If you can, please mark the formula as an answer as well, so anyone who is looking for the answer to your first question can find it. Enjoy your colorful sheet!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!