Linking two sheets using the AND, IF and OR functions

[TheBigHairyGinge]

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

 

[TheBigHairyGinge]

AND cell B18 in sheet A*

 

[TheBigHairyGinge]

I have solved my problem, thank you anyway!

Formula used:

=IF(OR('Cub Details'!B18=1,'Cub Details'!B18=5,'Cub Details'!B18=10,'Cub Details'!B18=15,'Cub Details'!B18=25,'Cub Details'!B18=50)*AND('Cub Details'!B18>'Badges - Autumn Term 2011'!B46),'Cub Details'!B18,"None Due")

 

[MC Planner]

Hi Alex,

Because you are checking the value of B18 multiple times with the OR function, you can shorten your formula to this...

=IF(OR('Cub Details'!B18={1,5,10,15,25,50})*AND('Cub Details'!B18>'Badges - Autumn Term 2011'!B46),'Cub Details'!B18,"None Due")

Hope that helps

Matt