A
Amanda D
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
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