Empty a cell if another cell's value is more than 1

**Haseeb123** · 12-08-2012, 02:02 PM

If the value of cell K2 goes above 1, the value of cell L2 should become zero?

**Luis21** · 12-08-2012, 02:05 PM

i think that can solve it with a simple formula

on cell L2 paste the following
=IF(F2>1,"0","")

**MarvinP** · 12-08-2012, 02:05 PM

Hi Haseeb123,

What should the value of L2 be if K2 < 0 ?

If it should stay the same as it is then you get circular ref error.

**martindwilson** · 12-08-2012, 02:11 PM

are -ve numbers involved? or just decimal like 0.8
but i cant see why
=IF(k2>1,0,k2) wont work

Re: Empty a cell if another cell's value is more than 1