SOLVED

formula in Excel

Copper Contributor

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

4 Replies
best response confirmed by balsaplayer (Copper Contributor)
Solution

@balsaplayer 

For example

 

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

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

@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.

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

Accepted Solutions
best response confirmed by balsaplayer (Copper Contributor)
Solution

@balsaplayer 

For example

 

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

View solution in original post