Ask Your Question
1

How to set a variable as a cell value [closed]

asked 2012-11-28 23:02:04 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How do I set a specific cell value as a variable on a worksheet to be declared throughout the workbook.

I am doing duty and VAT calculations and need to reference the cell for custom functions. As rates of Duty and VAT change I want anyone using the workbook to be able to change the value in the cell and therefore change the figures throughout the workbook.

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 02:49:41.674253

2 Answers

Sort by » oldest newest most voted
1

answered 2012-11-28 23:44:40 +0200

horst gravatar image

Click on the cell, Menue Data -> Define Range...; In the window that pops up enter a name , e.g. VAT and click Add, OK.

Now you can use the Cell as VAT in all sheets.

edit flag offensive delete link more
1

answered 2012-11-28 23:43:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

You can name one cell DUTY and another one VAT and use those names in place of cell references in formulas throughout the spreadsheet

Check help for names;defining for cells.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-11-28 23:02:04 +0200

Seen: 4,624 times

Last updated: Nov 28 '12