Thanks to all for their help.!!! -m
On Dec 6, 2:31 pm, 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
