View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP JP is offline
external usenet poster
 
Posts: 103
Default Create a formula with conditions

How can I create a formula for the following:

if A2 is <= 25 then * D8 by B4, and if A2 is <=25 but =50 then *D8 by B5,
and if A2 is<=50 but =100 then * D8 by B6?

So essentially if A2 is 0-25 then multiply D8 (a constant) by .10
and if A2 is 25-50, then multiply D8 by .2
and if A2 is 50-100, then multiply D8 by .4
and if A2 is 100-200, then multiply D8 by .5

Thanks for any help.

JP