View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default IF statement to calculate based on cell values

....and...another option:

=IF(AND(OR((B17={"S","F"})),C173),I17*K17,"")

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jos" wrote:

I am trying to get a cell to run a multiplication calculation on two cells
(i17 and k17), where one cell (b17) contains a fixed value ("S") or b17
contains a fixed value ("F") AND c17 has a value greater than 3. can anyone
help me with the expression I should use?