Construct a logical function IF statement which will return

Construct a logical function (IF statement) which will return a value of \"Bonus Applied\" if the value in C5 is after 2005 but earlier than February 1, 2015.

Solution

Bonus Applied = X

if (X > \'2005-01-01\' && X < \'2015-02-01\')

then X = C5

Else

X = NUll

-----