formula in Excel

[balsaplayer]

Hello i want to know how to make a cell in Excel return a value in another cell ?

example if Cell C2 is = or more than 1 then Cell K2 returns a positive value or a Tick

[#2 · Accepted solution]

@balsaplayer 

For example

=IF(C2>=1, "✓", "")

[#3]

Thank you that worked for Cell C2 but what i really wanted was if Cell C2 is more than 1 i want the Tick to be shown in Cell K2 if that is possible

[#4]

@balsaplayer 

The formula that I posted was supposed to be entered in K2.

It can be filled or copied down if required.

If that is not what you wanted, please explain in more detail.

[#5]

Hello thank you for Explaining i entered it in C2 thanks for your help