IF OR formula

[JMC57]

I am trying to create tow formulas that will enter the contents of A1 from sheet 1 in A1 of Sheet 2 and b1 from sheet 1 in b1 sheet2 and c1 from sheet1 on c1 sheet2 IF b1 in sheet 1 is is <7 or c1 sheet 1 is>12.


I hope you can help, Thank you in advance. </SPAN>

 

[Vidar]

Hi

Copy this formula in A1 of Sheet2 and drag across to B1 and C1:
=IF(OR(Sheet1!$B1<7,Sheet1!$C1>12),Sheet1!A1,"")

Vidar

 

[JMC57]

I am trying to create tow formulas that will enter the contents of A1 from sheet 1 in A1 of Sheet 2 and b1 from sheet 1 in b1 sheet2 and c1 from sheet1 on c1 sheet2 IF b1 in sheet 1 is is <7 or c1 sheet 1 is>12.


I hope you can help, Thank you in advance. </SPAN>

Thanks you for your quick reply

 

[Vidar]

You're welcome