How to store values in excel using macro ?

[pranavpk]

Hello there,
i'm new to excel..

i need Help in macros in excel

i want to know how to store the values using macros in excel . ?

as shown in table below,, the value of K vary as a/b vary. i want to write a macro such that the "a" and "b" values are entered in excel,the corresponding value of K should be taken by excel and shown in a specific box in excel sheet.

plz help


the table is as shown


a/b ----- 0.1 0.2 0.3 0.4 0.8 0.9 1.1 1.4 1.6 1.8 2

K-------- 4 4.2 4.4 4.8 5 5.5 5.6 5.8 5.9 6 6

 

[p45cal]

try:


(click on the thumb to enlarge)

 

[pranavpk]

Thank you p45cal ..
but is it possible to formula like this ?

If x <= 0 .1 Then
c = 4
ElseIf x <= 0.2 And x > 0.1 Then
c = 4.2
Else
c = 4.4
End If

 

[p45cal]

does:

Sub blah()
x = 0.15
c = Evaluate("INDEX({4,4.2,4.4,4.8,5,5.5,5.6,5.8,5.9,6,6},MATCH(" & x & ",{0,0.1,0.2,0.3,0.4,0.8,0.9,1.1,1.4,1.6,1.8}))")
'alternatively:
'c = Application.Index(Array(4, 4.2, 4.4, 4.8, 5, 5.5, 5.6, 5.8, 5.9, 6, 6), Application.Match(x, Array(0, 0.1, 0.2, 0.3, 0.4, 0.8, 0.9, 1.1, 1.4, 1.6, 1.8)))
End Sub

give the correct results?

 

[pranavpk]

Thank you p45cal ..

the code is working ...