 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Topic starter
Hello,
I need to report in a cell 'PASS' if H8-J8 is between -2 and +5 otherwise 'FAIL'
I've got it to work with AND, but would prefer to use IF so I get the words PASS and FAIL rather than the default true/ false.
=AND((H8-J8)>MIN(-2,5),(H8-J8)<MAX(-2,5))
It's hurting my (not too powerful) head this a.m.
Thanks as ever!
Dan
Posted : 03/07/2017 10:26 am
=if((h8-j8)<-2,"FAIL",if(h8-j8)>5,"FAIL","PASS")
Posted : 03/07/2017 10:30 am
Just put IF around what youhave
=IF(AND((H8-J8)>MIN(-2,5),(H8-J8)<MAX(-2,5)),"PASS","FAIL")
Posted : 03/07/2017 10:31 am
Just put the if supposition around what you have...
=if(AND((H8-J8)>MIN(-2,5),(H8-J8)<MAX(-2,5)),"pass","fail")
Posted : 03/07/2017 10:33 am
Topic starter
Thanks!!!
Posted : 03/07/2017 11:13 am