Try this:

=IF(AND(E3="ZEMO",M3="ZM"),U3,0)

Will only return U3 if both E3 and M3 contain the specified values.

Hope this helps.

Pete

On Jan 14, 11:47*am, enquirer2 wrote:
=IF(E3="ZEMO",U3,0)

I need to add reference to a value in another cell also and cannot
find how to do this.

The above looks at cell E3 and if it contains ZEMO returns the value
of cell U3. * I wish to modify the above formula to only show U3 value
if cell M3="ZM" *If it doesn't then 0 is shown in U3.

Can anybody help?