Hi I was wondering if anyone know the formula I need to use. I want to put a numericial value into a cell and for the cell beneath it to show the value of the first cell + 10% and the cell beneath that to show the second cells value + 10% of the second cells value and so on.
=sum(A1*0.10)+A1 done the same, so i could also work out interest on fixed amounts. Wanted to do more complex than this, (percentage on varying dates and values))but my head started hurting.
thanks I'm trying to work out a projected sales forecast and for some reason the figures keep skyrocketting.
ok, nice one, hope that helps, cant remember how i worked it out, i guess for others with spreadsheet experience, could do allsorts of stuff.
I've stuck with the first way as its allowd me to set up a couple of cells that effect the entire sheet so that I can show quarterly growth or (I hope not) quarterly losses so ended up looking like =SUM(B3*B26)+B3 that way I can change B26 to reflect a percentage of growth or loss.
I still don't get the point of SUM in this case. What is the difference between that and : Code: =B3*(1+B26/100) Where B26 is the percentage value.
It's just something that has to be typed I think. It's same for the roundup and rounddown functions. I've got one more formula I need to work out, but the GF is refusing to let me to work on the spreadsheet. She keeps mentioning something about the sound of grinding teeth and the anguished screams of hair being torn out. So I'm going to type it here and hope that someone can work it out for me. We have the option of buying stock by the container load. If we buy by the container load we have pallets of stock left over that I can not get to show up as I'm unsure how to do it. I'll give you an example. Month one we need 2.7 containers so we have to buy 3 containers. Month two we need 2.7 containers so we have to buy 3 containers. Month three we need 2.6 containers. Now according to the spreadsheet we have to buy 3 containers, but in reality we have a stored stock of 0.6 of a container so we would only need to buy 2 containers, but I can't work out how to get it work like that on the spreadsheet.
I think that you only need SUM if you are summing things together. Eg. you won't need it for simple addition/subtraction or multiplication/division, but you will need it for the ':' function that adds all the values between the two cells you set. Code: =SUM(A3:A7) would give you the summation of cells A3, A4, A5, A6 and A7. If you think about it this way - anything that requires values outside the ones you specify, require a function to work. A3+A5 specifies both A3 and A5, but A3:A5 does not specify A4 in the middle, therefore it needs the function to figure that out.
I had to change it any way as I realised that it was applying the wrong percentage of growth so it now looks like this =SUM(B3*B26/3)+B3 So that I can have the results shown for a monthly figure but I only have to enter a quarterly growth figure and it spreads the growth over the 3 months evenly. BTW Has anyone workd out the formula for the second problem (post #10)
