Dear watmatt Here is the formulae you required: =IF(A1<50,B2*(1.5),IF((A1>50)*AND(A1<100),B2*(1.4),IF((A1>500),B2*(0.97),IF((A1>1000),B2*(0.95),0)))) But if you put this formula in B2 cell. It will create circular reference.
You can look into the given attachment. Cheers.. Govind On Sun, Dec 7, 2008 at 2:01 AM, watmatt <[EMAIL PROTECTED]> wrote: > > Can you help me please? I have a bit of a situation and I need some > fresh eyes and brain power. I am trying to set up a spreadsheet for my > dad in excel and I have run into a formula snag. This is the last > formula I need to complete this worksheet and I need to get it right. > My brain hurts from trying to figure this out! Any help would be > greatly appreciated! > > Here is what I am trying to do. > > If A1 is less than 50 then add 50% to B2, But if A1 is more than 50 > but less than 100 then add 40% to B2. If A1 is more than 500 then > subtract 3% from B2, or if A1 is more than 1000 then subtract 5% from > B2. > > So far I can get the first part to work with: =IF > (A1<50,B2*0.5+B2) > > I can also get it to calculate correctly with: =SUM(A1<50)*SUM > (B2*0.5+B2) > > BUT I can't seem to figure out how to fit in the rest > > > > -- Raghuveer --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
need formula.xls
Description: MS-Excel spreadsheet
