Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
BrightEyes_PR
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel displaying formulae as constant and not calculating formula gpbell Excel Worksheet Functions 2 February 16th 06 09:26 AM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 06:30 AM
How can i get an If formula in excel to edit another cell? Jimmy Hoffa Excel Worksheet Functions 2 August 16th 05 05:53 PM
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"