| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula?-- if A1=11am, then D5=A1; if A1=12pm, then D10=A1
I need to create a log that goes hand in hand with this contract that I have.
Both are in Excel. The thing is I don't know if the following is possible nor if it is how would I write the formula. Here it is: If in the contract the cell D6 says 11:00am, then I need the rest of the fill-in info that's in the contract to come out in the log in the 11:00am row (D3-L3). If in the contract the cell D6 says 12:00pm, then the rest of the fill-in info in the contract should come out in the 12:00pm row (D11-L11). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula?-- if A1=11am, then D5=A1; if A1=12pm, then D10=A1 | New Users to Excel | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Threaded Mode
