Home

IF Function skip line if false

%3CLINGO-SUB%20id%3D%22lingo-sub-1119719%22%20slang%3D%22en-US%22%3EIF%20Function%20skip%20line%20if%20false%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119719%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20an%20IF%20Function%20where%20if%20the%20answer%20is%20%22false%22%20rather%20than%20just%20leaving%20a%20blank%20cell%2C%20Excel%20will%20automatically%20skip%20to%20the%20next%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20find%20in%20my%20example%2C%20that%20if%20a%20product%20is%20checked%20(in%20the%20checkbox)%20on%20sheet1%2C%20I%20want%20this%20product%20to%20appear%20in%20my%20table%20on%20sheet3.%20But%20for%20the%20time%20being%2C%20the%20table%20will%20also%20count%20the%20blank%20cells%20and%20this%20is%20very%20annoying.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%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-1121755%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20skip%20line%20if%20false%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526813%22%20target%3D%22_blank%22%3E%40emiliebm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20omitted%20to%20attach%20your%20example.%20Please%20try%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
emiliebm
Occasional Visitor

Hi,

 

I am trying to make an IF Function where if the answer is "false" rather than just leaving a blank cell, Excel will automatically skip to the next line.

 

You will find in my example, that if a product is checked (in the checkbox) on sheet1, I want this product to appear in my table on sheet3. But for the time being, the table will also count the blank cells and this is very annoying.

 

How can I do ?

1 Reply
Highlighted

@emiliebm 

You omitted to attach your example. Please try again.

Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies