ExcelBanter - Formula request

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula request (https://www.excelbanter.com/excel-discussion-misc-queries/132293-formula-request.html)

Serge

Formula request

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

daddylonglegs

Formula request

In sheet2!A1

=IF(Sheet1!A110,IF(Sheet1!A1<20,IF(MOD(Sheet1!A1, 2)=0,Sheet1!A1,"")))

"Serge" wrote:

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

All times are GMT +1. The time now is 03:12 PM.