View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default IF with multiple formula/variable

Hi,
Try:
=IF(I12="MRM",G12*$P$3,IF(I12="ME",G12*$P$4,IF(I12 ="AB",G12*$P$5)))
Regards - Dave