Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm seeking a formula for the following problem:
IF G2 = "a" or "a3" or "m" or "m3" or "ftm" AND H2 and K2 are populated with any value (that is, they are not blank cells), then the formula should return a value of 0.5 BUT if the G2 equals any of the above values AND H2 is populated with any value AND K2 is blank (has nothing in the cell), then the formula should return a value of 1 BUT if the G2 equals any of the above values AND K2 is populated with any value AND H2 is blank (has nothing in the cell), then the formula should return a value of 1 Can anyone help? many thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if then statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
IF and OR statements | Excel Discussion (Misc queries) | |||
More than 7 IF(AND) statements | Excel Discussion (Misc queries) | |||
If Statements... | Excel Discussion (Misc queries) |