View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default if/and statements

your brackets in the typed version are wrong
=IF(AND((e7+e8+e9)*450000,(e7+e8+e0)*4<100000),75 00*.25)