Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Formula?-- if A1=11am, then D5=A1; if A1=12pm, then D10=A1
=IF(D6=--"11:00:00",D3-L3,IF(D6=--"12:00:00",D11-L11,""))
is my guess -- HTH Bob Phillips (remove nothere from email address if mailing direct) "BrightEyes_PR" wrote in message ... 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). |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Formula?-- if A1=11am, then D5=A1; if A1=12pm, then D10=A1
Here's my guess - you have a contract sheet with cells in row 3
corresponding to 11:00 am (cells go from D3 to L3). You also have row 11 corresponding to 12:00 pm (cells D11 to L11). You want to set up a log sheet where cell D6 will contain either 11:00am or 12:00pm, and depending on these values you want to bring up the contents of cells D to L from the appropriate row of the contract sheet. If this guess is accurate, then enter this in cell D7: =IF(HOUR($D6)=11,contract!D3,contract!D11) then copy this formula across to E7:L7 Hope this wild guess works for you. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Formula checking multiple worksheets | Excel Worksheet Functions |