Excel question

%3CLINGO-SUB%20id%3D%22lingo-sub-1999309%22%20slang%3D%22en-US%22%3EExcel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999309%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20out%20if%20there%20is%20an%20IF%20formula%20for%203%20cells%20in%20a%20column%20(I%20know%20how%20to%20do%20one%20for%202%20cells%20but%20not%203).%20Also%2C%20they%20all%20need%20to%20be%20interdependent%2C%20that%20is%20if%20I%20change%20any%20to%20T%20(true)%20or%20F(false)%20the%20other%20two%20will%20change%20(to%20the%20opposite%20of%20what%20they%20are).%20Please%20help%20me%20find%20out%20if%20there%20is%20such%20a%20formula.%3C%2FP%3E%3CP%3Ethanx%2C%3C%2FP%3E%3CP%3ENeo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1999309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999590%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F905574%22%20target%3D%22_blank%22%3E%40nemanjapoluga%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20considered%20a%20nested%20IF%20statement.%20Based%20on%20what%20you%20are%20trying%20to%20calculate%2C%20the%20IF%20formula%20setup%20would%20change.%20For%20instance%2C%20we%20can%20combine%20OR%20or%20AND%20statements%20to%20simplify%20the%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20provide%20an%20example%20of%20how%20your%20data%20is%20set%20up%20and%20what%20you%20want%20the%20IF%20statement%20to%20show%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am trying to find out if there is an IF formula for 3 cells in a column (I know how to do one for 2 cells but not 3). Also, they all need to be interdependent, that is if I change any to T (true) or F(false) the other two will change (to the opposite of what they are). Please help me find out if there is such a formula.

thanx,

Neo

2 Replies

@nemanjapoluga 

This is considered a nested IF statement. Based on what you are trying to calculate, the IF formula setup would change. For instance, we can combine OR or AND statements to simplify the formula. 

 

Can you provide an example of how your data is set up and what you want the IF statement to show

@nemanjapoluga 

 

In general it is possible to write a formula to accomplish virtually any logical outcome. It is necessary, however, to spell out more completely what it is that you're trying to do here.

 

Could you possibly do that, spelling out this challenge more completely, ideally with an attached spreadsheet showing your own attempts, but more importantly giving an example or two of what three cells might contain, how they might change, what then you'd want the ultimate result to be.

 

IF you want to keep working on your own, which is fine--even recommended--I'd suggest looking into the IFS function, which covers multiple conditions more comfortably than does nesting a series of IF functions. Here's a website that might help: https://exceljet.net/excel-functions/excel-ifs-function