LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If statement using multi columns KReese Excel Worksheet Functions 5 June 2nd 06 02:57 PM
Anybody have a multi division income statement template? Inquiring Mind Excel Discussion (Misc queries) 0 May 18th 06 10:30 PM
If statement Matt Montagliano Excel Discussion (Misc queries) 1 September 8th 05 08:47 PM
Do I need a sumif or sum of a vlookup formula? PeterB Excel Worksheet Functions 0 June 1st 05 12:23 PM
How to express this in an if statement. kevin Excel Worksheet Functions 3 January 19th 05 07:13 PM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"