IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-2440632%22%20slang%3D%22en-US%22%3EIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440632%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3Ehi%20guys%2C%20i%20want%20to%20display%20an%20IF%20function%20without%20it%20showing%20unless%20i%20enter%20%22yes%22%20or%20%22no%22%20in%20the%20future.%20as%20you%20can%20see%20from%20G8%3AG22%2C%20you%20can%20see%20the%20%22unpaid%22.%26nbsp%3B%20how%20would%20i%20have%20it%20so%20it%20is%20just%20a%20blank%20space%20unless%20i%20enter%20%22yes%22%20or%20%22no%22%3F%20thanks%20all%3CSTRIKE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-11%20at%2019.07.28.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F288120iF8150BE8114FA002%2Fimage-dimensions%2F612x526%3Fv%3Dv2%22%20width%3D%22612%22%20height%3D%22526%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-11%20at%2019.07.28.png%22%20alt%3D%22Screenshot%202021-06-11%20at%2019.07.28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRIKE%3E%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2440632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2440833%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076994%22%20target%3D%22_blank%22%3E%40blakesjones%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20G8%20contains%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D%3CEM%3Esomeformula%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20this%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(F8%3D%22%22%2C%22%22%2C%3CEM%3Esomeformula%3C%2FEM%3E)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

hi guys, i want to display an IF function without it showing unless i enter "yes" or "no" in the future. as you can see from G8:G22, you can see the "unpaid".  how would i have it so it is just a blank space unless i enter "yes" or "no"? thanks allScreenshot 2021-06-11 at 19.07.28.png

1 Reply

@blakesjones 

Let's say G8 contains

 

=someformula

 

Change this to

 

=IF(F8="","",someformula)

 

Fill down.