What you describe is best accomplished by a macro rather than a formula . Take a look at the attached function (GetValue). If you have any questions let me know Tom
On Sat, Dec 6, 2008 at 3: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 -~----------~----~----~----~------~----~------~--~---
GetValue.xls
Description: MS-Excel spreadsheet
