On 2002-03-26 09:11, Adrae wrote:
Can anyone tell me what is wrong with this function. I'm trying to setup an "Or" scenario, where the value in less than OR equal to.
=IF(B4<Sheet1!E4,WIE!$F$6,(if B4=Sheet1!E4,WIE!$F$6,0))
Thanks
On 2002-03-26 09:22, Adrae wrote:
Well the error is gone, but the value is 0 no matter what. The values is Sheet1!E4 & B4 are dates formatted as MM/DD/YY. Could this be the problem, and if so, any ideas how to fix it?
If B4 is equal to or less than (comes before on calendar)E4 then I want to pull a specific value from another cell, else 0.
Thanks /board/images/smiles/icon_smile.gif