That wasn't the formula which the OP gave, Mike.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

This isn't clear. You can't have a formula that says

if(M3="ZM",U3=0)

formula can't push values they can only pull. Perhaps you could explain a
bit more clearly.

Mike

"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?