Hello,

What I'm trying to do with excel is the following.

If the cell K2 has a value that is less than 1 then i want the formula to return the value 1000 and if K2 is 1 or larger then it should return whatever is in AX2.

I've tried using the following formula:

=IF(K2<1;1000;AX2)

I even tried setting a cell B2 = 1000

and doing the following:

=IF(K2<1;$B$2;AX2)

It doesn't work, can any1 see why?