formulas or programing

[windseaker]

Ok , the way this should work is:


1) On sheet 2 in the 3 column( C4) starts the calculation with this value.
2) This value of (349.71) is entered into sheet 1 at cell (F2) and goes through another calculation and gave a value of 8934.91 in cell (F9).
3) (F9) is returned to sheet 2 at cell (B4).
4) Now the hard part. How do I get a continues returning values to full up the column from (B5 toB14)?


I have attached the problem,I was hope for just a vlooup but it appears to be more to it.
ITS 2007 excel

[Nirik]

Hi,
Hope i have understand ur query, n the sample calculated file will give u what u want. for calculation part see D column of sheet2. If any problem let me know.
Regards,
Nirik

[Nirik]

whether the formula provided by me was same which u were looking for or not. if ur querry solved then mark it as solved.
regards.

[windseaker]

you got it, I was over thinking it into a mass problem and its just a if statement ,
Thank you very much
Happy holidays

ps how do i mark it solved?

[Nirik]

hii again,
for marking it a solved, just click on thread tool just above the question
mentioned by U & then click on last option.
regards,