Need Help with MS Excel 2008 for Mac

[ovilla01]

Hi there,

I can't seem to figure out the correct function/formula to use in excel and i need your help. I would like to ask help in writing/typing in the correct formula for the scenario below:

If A1 is less than or equal to 10,000 then the value on, let's say, B1 would be 1,000. However, if A1 is more than 10,000 but less than or equal to 20,000 then the value on B1 should be 2,000. If A1 is more than 20,000 but is less than or equal to 30,000 then B1 should be 3,000 and so on and so forth.

I would really appreciate your help..thanks!

[Moo the Dog]

Try this and see if it works for you:

Please Login or Register  to view this content.

Please change the title of your post to something more specific to your problem, that way people will be able to find this post when searching for solutions to similar issues. Thanks.

-Moo

[JosephP]

try
=ROUNDUP(A1/10,-3)

[ovilla01]

thanks for the responses. i still can't seem to get the results that i'm expecting. Let me give you a more specific example. see below.

I'm trying to input the brokerage fee into the spreadsheet and this is how it looks like.

Up to 10,000 (Dutiable Value) the brokerage fee will be equivalent to 1,300
Over 10,000 and up to 20,000 (Dutiable Value) the brokerage fee will be 2,000
Over 20,000 and up to 30,000 (Dutiable Value) the brokerage fee will be 2,700
and so on...

so, what i'm trying to figure out with your help is how or what will be the formula/function in excel if for example you enter an amount of 10,001 (Dutiable Value) the return will be 2,000 since it's more than 10,000 as shown above.

Hope this helps.

Again, I appreciate your responses. Thanks!

[Moo the Dog]

See my attached sheet. It uses an INDEX/MATCH function.

- Moo

[ovilla01]

i think that'll solve my problem..i'll try it out and let you guys know! thanks for the help!

[ovilla01]

worked fine one last question though..if i were to add another formula from the one that you gave...below is the scenario:

if the dutiable value is over 200,000, deduct 200,000 from the given dutiable value and multiply the difference by .00125 then add 5,300..

what should i do? tried the IF function but i failed..

[ovilla01]

here's what i've done, =INDEX(G5:G12,MATCH(C3,F5:F12,1),IF(C3>200000,((C3-200000)*0.00125+5300))), but every time i enter an amount of more than 200,000 the result is #REF!...

[ovilla01]

got it at last...anyway, thanks for the help again!

[Moo the Dog]

Sorry, I was away - had to give the dog a haircut.
Glad to help, and hear you got it working the way you wanted.

- Moo

- - - - - - - - - -
If the solutions provided have solved your issue, please mark the thread as [SOLVED] by clicking on 'Thread Tools' above your first post and choosing 'Mark Thread as Solved'.

A great way to thank Forum volunteers for assistance is to click on the star located at the bottom-left corner of one of their posts. Feedback is always appreciated.

[JosephP]

@ovilla01
please don't forget to mark your thread solved and in future, as requested, please use a better thread title in accordance with forum rules (I admit I overlooked it earlier)