TheBigHairyGinge
New Member
- Joined
- Jan 27, 2012
- Messages
- 3
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 sheet A
Here is the formula I have so far:
=IF(AND((OR('Cub Details'!B18=1)),(OR('Cub Details'!B18=5)),(OR('Cub Details'!B18=10)),(OR('Cub Details'!B18=15)),(OR('Cub Details'!B18=25)),(OR('Cub Details'!B18=50)), ('Cub Details'!B18 > 'Badges - Autumn Term 2011'!B46)),'Cub Details'!B18,"None Due")
Thank you in advance for any help
Alex
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 sheet A
Here is the formula I have so far:
=IF(AND((OR('Cub Details'!B18=1)),(OR('Cub Details'!B18=5)),(OR('Cub Details'!B18=10)),(OR('Cub Details'!B18=15)),(OR('Cub Details'!B18=25)),(OR('Cub Details'!B18=50)), ('Cub Details'!B18 > 'Badges - Autumn Term 2011'!B46)),'Cub Details'!B18,"None Due")
Thank you in advance for any help

Alex