help with if formulas

[Lee Govan]

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 ?

[#2 · Accepted solution]

You may construct your formula similar to this:
=IF(A1<B1,Sheet2!A1,C1)

[#3]

@Twifoo 

thank you very much 

[#4]

@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 

[#5]

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)

[#6]

@Twifoo  Brilliant thank you

[#7]

You're welcome.