Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Grouping IF/AND/OR in a single formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping IF/AND/OR in a single formula
=IF(AND(H2=0,I2=0),"",IF(AND(H20,I2=0),"1",I2/H2))
HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Brad Wolosz" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping IF/AND/OR in a single formula
H1 I1 Results
0.0 0.0 10.0 0.0 1.0 6.0 5.0 0.8 0.3 0.1 0.4 1.0 0.8 0.8 0.3 0.2 0.8 0.6 0.0 1.0 0.5 0.5 1.0 0.0 0.6 0.5 0.1 0.2 =IF(H2=0,IF(I2=0,""),IF(I2=0,1,I2/H2)) Note that your described condition would produce error if H2 = 0, but I2 0 Jan "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |