Using variables in a formula...

[solarken]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

I have a need to create formulas that will adapt to 4 variables from a single cell and repeat these in many rows... Each variable must return a key to act as a variable for a second cell to complete the calculation...

Lets say cell A10 is the input cell for the variables and that A remains the variable column for each row...

B + C are for date entry that is being computed.

D10 (or other in other rows) is the first formula.

The entry in A10 will be a letter, A,B,C,D...

A denotes a multiplier of 10. B is 20 and so on...

So if you enter a C in A10, 2 in B10, 5 in C10

D10 must see C from A10 as 30 and complete the following =30*B10*C10 for a result... in this case 300... or in the case of A01 being an A it would be 100 as a result in this example.

E10 follows suite and if A10 is a C it takes D10s result and multiplies it by the second variable assigned to C... 300%...

So far I have tried a number of ways but have had no good results...

Any Ideas???

Thank you,

Ken

 

[solarken]

The A01 is a typo... =A10

Sorry

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello,

I have a need to create formulas that will adapt to 4 variables from a single
cell and repeat these in many rows... Each variable must return a key to act
as a variable for a second cell to complete the calculation...

Lets say cell A10 is the input cell for the variables and that A remains the
variable column for each row...

B + C are for date entry that is being computed.

D10 (or other in other rows) is the first formula.

The entry in A10 will be a letter, A,B,C,D...

A denotes a multiplier of 10. B is 20 and so on...

So if you enter a C in A10, 2 in B10, 5 in C10

D10 must see C from A10 as 30 and complete the following =30*B10*C10 for a
result... in this case 300... or in the case of A01 being an A it would be 100
as a result in this example.

E10 follows suite and if A10 is a C it takes D10s result and multiplies it by
the second variable assigned to C... 300%...

So far I have tried a number of ways but have had no good results...

Any Ideas???

Thank you,

Ken

I'm not sure what you are trying to do, You explanation is unclear. However
look in Excel Help for CHOOSE it may be what you want. If not, post again.

 

[solarken]

Thanks for that input... I will check and let you know if I can make it work with that...

Ken

 

[Carl Witthoft]

On 2/23/09 1:53 PM, in article (e-mail address removed)9absDaxw,

I'm not sure what you are trying to do, You explanation is unclear. However
look in Excel Help for CHOOSE it may be what you want. If not, post again.

Couldn't the OP just use CODE(A10) ? He'd have to apply a static
offset, e.g. =(CODE(A10)- 96)*10 but that would seem to do it.

 

[JE McGimpsey]

So far I have tried a number of ways but have had no good results...

the suggestion to use CODE() is a good one, but I'd go one step further,
since your user could enter both lowercase and uppercase:


D10: =B10 * C10 * 10 * (CODE(UPPER(A10))-64)

 

[solarken]

I will look at this idea this morning... Thank you

Ken