EXCEL HELP!

File: 25 KB, 360x360, EBP.jpg [View same] [iqdb] [saucenao] [google]

EXCEL HELP! Anonymous Mon May 16 22:41:03 2011 No.3070046 [Reply] [Original]

Does anyone on /sci/ know how on excel 2007 I can make a drop down box with numbers 1-100 in sequential order (or any type of scrolling drop down). I would prefer if there was a way to do it other than making a column of the numbers 1-100 and making it a group. Im setting up a sheet where I can select lets say for example 8 apples and it will multiply it by cost say .39$(in another column) then the next row it will have 9 bananas for .86$ and the total will be at the bottom. I am also copying this to /g/ but I hope you guys can help.

* is where i need help.
eg

product amount* price

computer 9* 400$
apples 4* .39$

total xxx.xx$

Thanks!

>>	Anonymous Mon May 16 22:43:03 2011 No.3070064 bamp from down below

>>	Anonymous Mon May 16 22:46:03 2011 No.3070085 anyone?

Advanced search
Text to find
Subject [?]Search by post subject. Leave empty for any.
Username [?]Search for user name. Leave empty for any user name.
Tripcode [?]Search for tripcode. Leave empty for any.
Email [?]Search by email. Leave empty for any.
Filename [?]Search by image filename. Leave empty for any.
From Date [?]Enter what date to start searching from. Format is YYYY-MM-DD
To Date [?]Enter what date to start searching until. Format is YYYY-MM-DD
Image hash
Search in	All Posts OPs Only
Deleted posts	Show all posts Show only deleted posts Only show non-deleted posts
Internal posts	Show all posts Show only internal posts Show only archived posts
Order	New posts first Old posts first
Capcode	All Posts Only by Users Only by Mods Only by Admins Only by Developers
Results	Posts Threads
Action	[ Simple ]

/sci/ - Science & Math