Hi Can you help me please. i want excel password breaker.,..... On Wed, Dec 10, 2008 at 7:47 AM, watmatt <[EMAIL PROTECTED]> wrote:
> > 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 > > > > -- Chandra Singh Bohra Champawat Uttrakhand 09717336333 [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
