If then Formula

[mdonovan890]

I am having an issue with an IF/Then formula in Excel. If cell B has a value greater than 30 then I want the data from cell I2 to be placed in cell A. For example, when 2300487724 is imputed into B2 I want 01/09/2017 to appear in A2.

 

[Michael M]

Try in A2

=IF(B2>30,I2,"")

 

[SQUIDD]

try this

=IF(B2>30,I2,"")

dave