SOLVED
Home

help with if formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-413335%22%20slang%3D%22en-US%22%3Ehelp%20with%20if%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-413335%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20guys%20is%20it%20possible%20to%20create%20a%20formula%20in%20a%20cell%20that%20refers%20to%20whether%20another%20cell%20is%20less%20than%20a%20number%20and%20then%20so%20it%20can%20copy%20text%20from%20another%20cell%20in%20a%20different%20sheet%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-413335%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-413429%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20if%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-413429%22%20slang%3D%22en-US%22%3EYou%20may%20construct%20your%20formula%20similar%20to%20this%3A%3CBR%20%2F%3E%3DIF(A1%3CB1%3E%3C%2FB1%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-415084%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20if%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415084%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20very%20much%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-415312%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20if%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415312%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eonly%20one%20problem%2C%20how%20do%20i%20stop%20it%20saying%20FALSE%20when%20it%20doesn't%20fall%20within%20the%20formula%20to%20copy%20the%20text%20i%20want%20%3F%20%26nbsp%3Bi.e.%20i%20want%20the%20cell%20to%20remain%20blank%20or%20copy%20the%20text%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Lee Govan
Occasional 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
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies