Thread: IF AND problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amanda D Amanda D is offline
external usenet poster
 
Posts: 1
Default IF AND problem


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