Hi,
I am trying to make a formula that works something like;
=IF([LOGICAL TEST]Date x<=Date y BUT Date x>Date z, [IF TRUE]Cell A, [IF FALSE]Cell A +1 row down AND +1 row down from Date x in the LOGICAL TEST part)
Essentially I am trying to make a model in which a specific value corresponds to any time between 2 dates. The value that corresponds to that range of dates is used until the date in the model (which changes) exceeds that given date range. Once that happens I want to next cell below Cell A to be used AND the date range in the logical test to change as well.
Any help to work out this formula or suggestions for a different approach much appreciated
Cheers,
Dan
I am trying to make a formula that works something like;
=IF([LOGICAL TEST]Date x<=Date y BUT Date x>Date z, [IF TRUE]Cell A, [IF FALSE]Cell A +1 row down AND +1 row down from Date x in the LOGICAL TEST part)
Essentially I am trying to make a model in which a specific value corresponds to any time between 2 dates. The value that corresponds to that range of dates is used until the date in the model (which changes) exceeds that given date range. Once that happens I want to next cell below Cell A to be used AND the date range in the logical test to change as well.
Any help to work out this formula or suggestions for a different approach much appreciated
Cheers,
Dan