View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 141
Default How to Express a Multi IF Statement Q

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