Hey,

So the problem that I want to try and resolve is that I need a cell to look at a word as a number value, then subtract a number off of the word value, compare that value to another number and say whether it passes or fails.

Example

C1=PumpA
C2=12
C3=Result

I tried to write it myself and it looked something like this.

=IF(C1="PumpA", ((C2-10)<10)="Fail", "Pass")

Please Help!