Clear the Cell

[dgavin]

In cell K18

=If G2=K18, then when D20 is less or greater than E20 then clear K18

Can you put this in a formula

Thanks

 

[MrKowz]

Is this what you need? The wording of that logic was a bit unorthodox:

=IF(D20<>E20,"",G2)

This is when D20 is not equal to E20, then show a blank, otherwise show G2.

 

[dgavin]

Thank you

Slight change

=If G2=K18, then when D20 is less than E20 - 0.10 or greater than E20 + 0.10 then clear K18

 

[MrKowz]

Try:

=IF(ABS(D20-E20)>0.1,"",G2)