View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Problem with link

Try this:

=IF(B1=1,B1*9,IF(B1=2,B1*8,B1*4))

Pete