Try the following formula....
=B2+B2*INDEX({-0.05,-0.03,0,0,0,0.4,0,0.5},MATCH(A1,{2000,1000,500,499,100,9
9,50,49},-1))
Values Of A1 Operation
============ ==========
Upto 49 B2 * 50%
50 Unchanged
51 to 99 B2 * 40%
100 to 500 Unchanged
501 to 1000 -(B2 * 3%)
> 1001 -(B2 * 5%)
Regards
Ajit
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of watmatt
Sent: Sunday, December 07, 2008 2:01 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ formula help
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
-~----------~----~----~----~------~----~------~--~---
