Cell A1 = X when Cell B1 > or = Y

[PVH]

How do I cause a cell to have a specific fixed value if another cell has a value which is equal to or greater than some other specific value?

[Pepe Le Mokko]

Hi
something along the lines of
=If(B1>=your_value,fixed_value, something else)

[PVH]

Thanks Mokko this worked perfectly!