J
John
How can I express the following in a formula
If B1 is greater than 4.5 but less than or = 5.9 AND B2 <0.15 THEN "Less
than Min" +
If B1 is greater = 4.5 AND B2 <0.15 THEN "Less than Min" +
If B1 is greater than 4.5 but less than or = 5.9 AND B2 >0.15 THEN "Blank" +
If B1 is greater than 5.9 AND B2 <0.30 THEN "Less than Min" +
Otherwise "Blank"
Overall if B1 < 4.49 then it doesn't matter whats is B2, formula should
return "Blank", and if B1 = 0, then "Blank" also regardless f whats in B2
I hope I've made it clear and covered all scenarios. The above should be in
one cell hence the + I've used. I'm just getting confused trying to
construct it
Thanks
If B1 is greater than 4.5 but less than or = 5.9 AND B2 <0.15 THEN "Less
than Min" +
If B1 is greater = 4.5 AND B2 <0.15 THEN "Less than Min" +
If B1 is greater than 4.5 but less than or = 5.9 AND B2 >0.15 THEN "Blank" +
If B1 is greater than 5.9 AND B2 <0.30 THEN "Less than Min" +
Otherwise "Blank"
Overall if B1 < 4.49 then it doesn't matter whats is B2, formula should
return "Blank", and if B1 = 0, then "Blank" also regardless f whats in B2
I hope I've made it clear and covered all scenarios. The above should be in
one cell hence the + I've used. I'm just getting confused trying to
construct it
Thanks