LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default Grouping IF/AND/OR in a single formula

"Brad Wolosz" wrote:
Here is what I am trying to acomplish
IF H2=0 AND I2=0, ""
IF H20 AND I2=0 "1"
ELSE I2/H2


=if(or(I2<0,H2<0),I2/H2,if(H20,"1",""))


----- original message -----

"Brad Wolosz" wrote in message
...

Hi all

I am trying to creat a formula by grouping multiple conditions
and just cant seem to get it to work

Any ideas would be of great help

Here is what I am trying to acomplish

IF H2=0 AND I2=0, ""
IF H20 AND I2=0 "1"
ELSE I2/H2

Thanks for any input given

Brad




--
Brad Wolosz


 
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
Formula for Grouping Ingus Smith[_2_] Excel Discussion (Misc queries) 1 February 9th 09 04:36 PM
I need a formula for grouping data Debbie60 Excel Worksheet Functions 1 January 20th 09 12:53 PM
grouping instead of single cell misscharliebrown Excel Discussion (Misc queries) 5 November 6th 08 10:07 PM
Pivot table, grouping by formula BWHANDY Excel Discussion (Misc queries) 0 May 11th 06 11:26 AM
Grouping & Formula Gabe Excel Discussion (Misc queries) 3 January 19th 06 05:56 AM


All times are GMT +1. The time now is 04:07 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"