sheet for calculations

[mukcl]

Hi peeps. I have tried searching a bit for what I am looking for but it
hard to put a name or keyword, I ma sure you guys will come up with i
straight away.

If you look at the excel file, I need to fill in the options and have
total generated. I have no idea how to do this. I guess its a kind o
referencing to other cells.

I think this is way more simple than I have made it out to be
Hopefully you peeps can help me out, I will attach the file, this wil
give you a better idea I think.

CHeers!
Mik

+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelforum.com/attachment.php?postid=5160
+-------------------------------------------------------------------

 

[Franz Verga]

Hi peeps. I have tried searching a bit for what I am looking for but
its hard to put a name or keyword, I ma sure you guys will come up
with it straight away.

If you look at the excel file, I need to fill in the options and have
a total generated. I have no idea how to do this. I guess its a kind
of referencing to other cells.

I think this is way more simple than I have made it out to be.
Hopefully you peeps can help me out, I will attach the file, this will
give you a better idea I think.

CHeers!
Mike

Hi Mike,

I think you can use Data validation (menu Data, Data validation) and few
VLOOKUP formulas, as from you file modified at this link:

http://rapidshare.de/files/30600496/Book2_-_modified.zip.html

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy