Logic formula for calculating between two dates

[sofib09]

I need to calculate some construction costs using a reference table provided on another tab.

I'm trying to use the IF(AND) function to determine if the current month is between the two months of construction, and if so, use the vlookup function to find the construction costs and multiply them by the costs and % ownership, otherwise, have it equal to zero.

I have included the formula I am using-- am I missing something here? What can I do to fix this? Thanks so much!


=if(and(G6>=$A$7,G6<=$C$7),vlookup($B$4,'Reference Tables'!$K$2:$W$7)*$F$7*$D$8),0))

[zbor]

You miss what column to return with VLOOKUP function:

vlookup($B$4,'Reference Tables'!$K$2:$W$7, 3, FALSE)

[sofib09]

I'll give it a try...thanks!

[sofib09]

Didn't seem to work. Are there some sort of logic formula limitations when it comes to dates?

I'm not too familiar with this.

[zbor]

Can yoiu upload example workbook?

(Also, 3 was just an example).

[sofib09]

Yes, I finally figured it out...thanks!

[R3CON3D]

Im trying to work with a formula that it nesting, here is the formula I can currently working with,

=IF(AND(AB2>=$J$6,AB2<=$K$6),IF($J$6=AB2,$M$6*0.25*$L$6,IF($J$6+1=AB2,$M$6*0.5*$L$6,0)*0),"0")

I think where im going wrong is the "$J$6+1=AB2" section. All im trying to do with the 6+1 feature is take my J6 cell (which is first month of production) and move onto the next cell which will change multiplication of .25 to .50, any advice on how to get this to work?

[arlu1201]

R3CON3D,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

[R3CON3D]

opps im sorry I was not aware of that, ty!