Greater then statement

[Emb21]

Hello,

I'm doing a greater/less then statement.

if B70 is greater then D70 then show Sheet2 Cell B1, if not it will equal zero

Thank you,
Eric

 

[anubis]

Hello Emb21

Try this:

=IF(B70>D70,Sheet2!B1,0)

 

[PA HS Teacher]

Alternatively, If Sheet2!B1 is always a number you could do,

=(B70>D70)*Sheet2!B1