ExcelBanter - If statement

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If statement (https://www.excelbanter.com/excel-worksheet-functions/110315-if-statement.html)

Dohickle

If statement

I need a statement that (+IF (j2) < today etc) that if this is true will copy
that cell from one sheet to another sheet can anyone help please.

Roger Govier

If statement

Hi

You cannot use any formula to cause a cell to be copied to another
sheet.
You can make the contents of a cell equal the value held in another cell
on another sheet.
For example, on Sheet1
=IF(J2<TODAY(),Sheet2!A1,"")

--
Regards

Roger Govier

"Dohickle" wrote in message
...
I need a statement that (+IF (j2) < today etc) that if this is true
will copy
that cell from one sheet to another sheet can anyone help please.

All times are GMT +1. The time now is 05:08 AM.