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 -~----------~----~----~----~------~----~------~--~---
