| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LONG IF (diff columns) STATMENT(s)
i have a complex if statement that i need help with. I have a contract that
tells to post a price from different days then from the day the price was published. I need a formula that will give me Thursday's price for Monday etc. Day Price Publication Price Mon Thurs (3days after mon) Tue Fri (" ") Wed Sat(" ") Thurs Mon Fri Wed Sat/Sun Wed I have the day (ddd) in one column - can i reference back to that somehow? day(ddd) is in column c, the price is in column w, how can i tell column s to give me thurs price for the monday cell, etc based on the price date parameters? Is there even a way? thx for all your help in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert multiple columns into one long row | Excel Discussion (Misc queries) | |||
| Message or input | Excel Discussion (Misc queries) | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
Threaded Mode
