Hi,
I am trying to link two sheets in the following way and for the purpose of ease I'll call the sheets A and B.
IF cell B18 in sheet A is greater than cell B46 in sheet B
AND cell B18 in sheet B is equal to 1 OR 5 OR 10 OR 15 OR 25 OR 50
then cell B90 in sheet B should equal cell B18 in...