SOLVED

help with if formulas

Copper Contributor

hi guys is it possible to create a formula in a cell that refers to whether another cell is less than a number and then so it can copy text from another cell in a different sheet ?

6 Replies
best response confirmed by Lee Govan (Copper Contributor)
Solution
You may construct your formula similar to this:
=IF(A1<B1,Sheet2!A1,C1)

@Twifoo 

 

thank you very much 

@Twifoo 

only one problem, how do i stop it saying FALSE when it doesn't fall within the formula to copy the text i want ?  i.e. i want the cell to remain blank or copy the text 

You just have to modify the value_if_false argument. If you want FALSE to return blank, your formula will be like this:
=IF(A1<B1,Sheet2!A1,"")
Nonetheless, if you want FALSE to copy A1, your formula will be like this:
=IF(A1<B1,Sheet2!A1,A1)

@Twifoo  Brilliant thank you

You're welcome.
1 best response

Accepted Solutions
best response confirmed by Lee Govan (Copper Contributor)
Solution
You may construct your formula similar to this:
=IF(A1<B1,Sheet2!A1,C1)

View solution in original post