help with an "IF" function

[Pauls123]

hi there, Using Excel 2010, I want to perform the following function. Say if Cell G2 has a currency figure in it, (eg $2.50), then I want cell L3 to equal cell I2. But if cell G2 has a zero currency figure in it, (eg $0), then I want cell L3 to also be $0.

Any advice please,

Regards, Paul

 

[VoG]

Try

=IF(G2>0,I2,0)

 

[andrewkard]

Hello, in L3:

=IF(G2=0,0,I2)

 

[andrewkard]

Try

=IF(G2>0,I2,0)