Formula request

S

Serge

I need a formula in sheet 2 that will copy or equal a cell in sheet 1 but
only if matches 3 (and or) 4 criterias.

Your help is much appreciated.
Many thanks
Serge
 
D

daddylonglegs

In sheet2!A1

=IF(Sheet1!A1>10,IF(Sheet1!A1<20,IF(MOD(Sheet1!A1,2)=0,Sheet1!A1,"")))
 
Top