Try this in A4 dragged to the right. If the monthly number is odd, it adds 1 to the first monthly value (i.e. if the total is 81, you'll get 41 and 40)
Does this work for you?
=IF(MONTH(A3)=MONTH(B3),ROUNDUP(HLOOKUP(A3,$A$1:$D$2,2)/2,0),ROUNDDOWN(HLOOKUP(A3,$A$1:$D$2,2)/2,0))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It works for the cell I originally type the formula in, but I'm getting a #N/A when I try to copy it into other cells in the same row. I don't this problem on the example sheet. It works fine. Is there something I should look out for that would cause this issue?
=AP11+(IF(MONTH(AQ2)=MONTH(AR2),ROUNDUP(HLOOKUP(AQ2,Sheet1!L1:$BQ$5,5)/2,0),ROUNDDOWN(HLOOKUP(AQ2,Sheet1!L1:$BQ$5,5)/2,0)))
Never mind, it was the $ sign on the first portion of the range of the Hlookup.
Last edited by kgibson20; 02-28-2012 at 01:09 PM.
It appears that I'm having a rounding issue at the end. On my first line item I was off 57 on 3000+ hours. Anyway to correct this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks