Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for Grouping | Excel Discussion (Misc queries) | |||
I need a formula for grouping data | Excel Worksheet Functions | |||
grouping instead of single cell | Excel Discussion (Misc queries) | |||
Pivot table, grouping by formula | Excel Discussion (Misc queries) | |||
Grouping & Formula | Excel Discussion (Misc queries) |