SOLVED

# formula in Excel

Copper Contributor

# formula in Excel

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

# Re: formula in Excel

For example

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

# Re: formula in Excel

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

# Re: formula in Excel

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.

# Re: formula in Excel

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

# Re: formula in Excel

For example

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