i run a feed and seed company and im wanting to take my wholesale cost of all the different seeds that i carry and use my conversion sheet to automatically convert to my retail prices. example if i have seed that range from 0-$30 then its key( which is double) + $25 rounded to the nearest $4.99 so if the seed is $65 then it will be $64.99 not $69.99 . how do i make a formula for this? again here is the example if the bag of seed falls between 0-$30 its doubled + $25 rounded to nearest $4.99 any help would be greatly appreciated.
Last edited by inyourneck2004; 07-06-2011 at 01:42 PM.
That's better... but if still want to go elsewhere... that is your choice. You will find that we are helpful bunch... but we expect some rules will be followed to keep this a useful resource..... I deleted the trail of previous posts.....
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Thanks maybe ill get a response for this now
Does this work?
=CEILING(A2*2+25,5)-0.01
where A2 contains the original price
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
yes sort of. is there a way the we could do a formula that states if column a's price range is from 0-$30 then use that formula but i would also like it to state that if column a's range is from $31- $50 then use this formula =CEILING(A:A*2+20,5)-0.01 then if its range is from $51-$70 then use this formula =CEILING(A:A*2+15,5)-0.01 am i confusing you on this cause i think im about to confuse myself lol if there is not a way to do this then its not a big deal
Try:
=CEILING(A4*2+LOOKUP(A4,{0,31,51},{25,20,15}),5)-0.01
you can add to the {} ranges if you have more breakdowns.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
By that we mean provide the new title or ask for help from a mod, not we'll just do it for youTo change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
thanks ill try it in a lil while and if it works ill change my title to solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks