I am on microsoft excel and i am trying to put in a formula instead of doing all the work myself. The formula/scenario is this:
y=(600-6x) (10+.5x)
X equals the number of increases, which should start at zero, and end at 100. Y is the gross sales (in this problem the gross sales of fruitcake but that shouldnt matter)
so my table should look as described:
column A:
x (# of increases)
Column B:
Price
Column C:
# of cakes sold
Column D:
Gross sales (Y)
Hopefully i have given enough information for help! You can either give me directions as to how i should set up this, or do it for me and post it online or something.
The timesaver im trying to accomplish here is from having to take column B and go all the way down to one hundred, increasing from .50 each new cell. You could just tell me how to make it do that.
Thanks for any and all answers!
|
||
Can You Help Me Set Up A Formula On Microsoft Excel?3 comments to Can You Help Me Set Up A Formula On Microsoft Excel?Leave a Reply |
|
|
|
Copyright © 2012 Verified Website - All Rights Reserved |
||
First for column B. I assume your beginning from .5 and going all the way to 100. I would put .5 in column B1 and in B2 put the following formula in “=b1 +.5″ and copy the formula down. In Column D1 I would add the formula “=((600 – (6*A1))*(10 + (A1)/2))”
An alternative way of writing the formula (by expanding the brackets) would be “=6000 + (240* a1) – (3*(a1)^2)”.
Coulmn A & C looks like it is done manually.
Hope this helps and not to confusing.
[...] See the example place here: Can You Help Me Set Up A Formula On Microsoft Excel? | Verified … [...]
Is there a way to verify URL destinations in Excel (where it will tell you what sites are valid are which ones are not)?