| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need an advice in excel sheets....
hi!
I am preparing a basic calculator for myself for some funds and I got into a trouble... there is a excel file U can download... http://www.andergrant.com/problem.zip so.. "a, b, c, d, e, f" sheets are the names of funds the problem is in the sheet called 'main' in the cell F109. I want this cell to feedback me the number taken from sheet 'a' from the row number 4 BUT !!! - I WANT IT TO FEEDBACK IT FROM TODAY!!! (I want to query to compare/check today's date and answer with a proper number under the today's date). So the feedback for such a query for today (2004-11-27) should be 5049,92. If today's would be 2004-11-22 the feedback for sheet 'a' would be 5050,11 - I hope U are enable to see it... Please give me a hand with it - I would be very thankfull thx.up front m. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
| Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
| No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
