Default value of list cell

**bigcurt** · 02-05-2015, 11:02 PM

Hi,

So, first a little background...

I am wanting to make a document that will show the user the cost price of an object that they pay the company I work for by default. But then, I have a formula/table setup with a list they can choose from of different values to multiply all those cost cells by that select value. For instance, their cost * 2.5 will get their suggested MSRP for that product. Understand? Sorry if I am not explaining correctly. Anyway, because of that though I must have a list with a default value when the sheet is launched to "1" or else it will not show their cost price first in the sheet. Is there an easy way of doing this? Or, am I missing an easier way to do this all together?

Thanks a ton for your help!

**FDibbins** · 02-06-2015, 02:20 AM

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**bigcurt** · 02-06-2015, 08:52 AM

Attached is the file itself. In the first 3 cells of the first table to the left I have added the calculation I was talking about that changes the price based on what's in the drop down. If someone has a better way of doing that, let me know.

Thanks!