Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I am trying to return a sum using IF AND My obejective is IF E9 = 3 AND ISNUMBER in Z9 then take F9 multipled by BE9, G9 multiplied by BF9, H9 multiplied by BG9 and so on. F9, G9 & H9 will be various amounts for different products. I have percentages in BE9, BF9 & BG9 This is what I have tried: =IF(AND(E9=3,ISNUMBER(Z9)),(F9*BE9,G9*BF9,H9*BG9,0 ) I know that the formula is incorrect, please can anyone help? Many thanks Amanda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |