Is there a formula in excel that allows you to assign a value to a variable?

You can name a cell. Put the values into some cells and then look under tools, or maybe right click on a cell. I don't have Excel right here otherwise I'd check for you.

You can always use the help and search for 'naming'.

In Excel, the best way to do this is to put the values into cells and use the cell references in the formula. For instance, you could put A into cell A1, B into cell A2, C into cell A3 and D into cell A4. Then to evaluate, say, B+A-4CD, you'd enter into another cell the formula:

= A2 + A1 - 4 * A3 * A4

your problem can be better solved by not using formulas in excel. Instead use 'macros' in the excel sheet to use these kind of assigned variable values.

if input data into a cell that has a formula it will replace the formula.

if the cell is part of a formula, it works but then that input is permanent until you type something else in its place.

your formula has to call variables from cell location on the spreadsheet where you input the data.

Naming is the right answer, but it would be even cleaner to use named constants and avoid needing to type data in a cell.

http://www.ozgrid.com/Excel/named-constants.htm

well you couldjust let cells be ur A,B,C,D

e.g. click on A1 and type 4

click on b2 and type 5

Then if u want to use these as variables click on say c1 and type " = A1*B2 " and it will multiply these cells using them as variables as in conclusion in this case A = A1