|
How can I get Microsoft excel to calculate increasing number again
I am a small business owner and what I need is to price my inventory. Let's
say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost ( $10.000) will be multiplied by 2%? Is there a formula to do it and if yes,,,what it is? Somebody suggested I should use the Conditional Formatting/Formula. Is it the best for my need and if yes, how do I do it? Can you give me more details? Thanks in advance! |
How can I get Microsoft excel to calculate increasing number again
Conditional Formatting is for colouring or formatting the cells that you want highlighted... You need to better explain what you are trying to accomplish... are you only wanting to multiply the minimum and maximum numbers by new numbers, etc... -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111150 |
How can I get Microsoft excel to calculate increasing number a
Thank you for your fast answer.
What I am trying to do is basically to be able to have regressing percentage against my increasing cost. My cost is in a column sorted from lowest to highest . I want to be able to add on the next column a formula with which with one click to apply this formula to all the cells in the same column (as we do with all formulas). So,,,if at the starting point of $0.01cost I have in the formula added 20% [sum= A1*1.20], at the end of my cost list to have only 2% added [ sum=A12510*1.02]. Sample of what I am trying to accomplish: $50 x 12% $ 51 x 11.99% $ 52 x 11.98% $ 53 x 11.97% and so on... How do I do it? Thanks again for your help! "NBVC" wrote: Conditional Formatting is for colouring or formatting the cells that you want highlighted... You need to better explain what you are trying to accomplish... are you only wanting to multiply the minimum and maximum numbers by new numbers, etc... -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111150 |
How can I get Microsoft excel to calculate increasing number again
Hi,
Set up a rate table like 0.01 20% 100 19% 500 18% .... 10,000 2% suppose this is in the range M1:N20 then use a lookup function =VLOOKUP(A2,$M$1:$N$20,2,TRUE)*A2 Where A2 contains the cost of an item. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Anna" wrote: I am a small business owner and what I need is to price my inventory. Let's say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost ( $10.000) will be multiplied by 2%? Is there a formula to do it and if yes,,,what it is? Somebody suggested I should use the Conditional Formatting/Formula. Is it the best for my need and if yes, how do I do it? Can you give me more details? Thanks in advance! |
How can I get Microsoft excel to calculate increasing number again
Anna;398162 Wrote: Thank you for your fast answer. What I am trying to do is basically to be able to have regressing percentage against my increasing cost. My cost is in a column sorted from lowest to highest . I want to be able to add on the next column a formula with which with one click to apply this formula to all the cells in the same column (as we do with all formulas). So,,,if at the starting point of $0.01cost I have in the formula added 20% [sum= A1*1.20], at the end of my cost list to have only 2% added [ sum=A12510*1.02]. Sample of what I am trying to accomplish: $50 x 12% $ 51 x 11.99% $ 52 x 11.98% $ 53 x 11.97% and so on... How do I do it? Thanks again for your help! Say you have your costs currently in A2, downwards... Use an input cell for starting rate of 12% or 0.012(e.g. Cell D1) and another input cell for the change in rate. of 0.01% or 0.0001 (e.g. Cell E1)... then use formula in B2, copied down.. =A2*($D$1-($E$1*(ROW($A1)-1))) You can change your input values as needed to automatically update formula results... -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111150 |
| All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com