Autofill a cell through formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1959626%22%20slang%3D%22en-US%22%3EAutofill%20a%20cell%20through%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959626%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20fill%20a%20formula%20say%20you%20type%201%20and%20it%20fills%20out%20True%3C%2FP%3E%3CP%3Eor%202%20and%20it%20fills%20out%20false%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20make%20a%20formula%20like%20this%20row%20dependent%3F%20so%20for%20row%202%2C%201%20may%20mean%20yes%20instead%20of%20true%20on%20row%201%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1960283%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20a%20cell%20through%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892243%22%20target%3D%22_blank%22%3E%40arthurvico%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20general%20answer%20to%20your%20general%20question%2C%20%22Is%20it%20possible%3F%22%20is%20%3CU%3E%3CEM%3E%3CSTRONG%3Eyes%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20be%20more%20specific%20with%20an%20actual%20function%20or%20formula%2C%20you%20will%20need%20to%20be%20more%20specific%20in%20what%20those%20conditions%20are.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20has%20a%20lot%20of%20ability%20handle%20complex%20IF.....THEN%20conditionals%2C%20handling%20multiple%20conditions%2C%20sub-conditions%20and%20all.%20But%20we%20the%20users%20need%20to%20be%20very%20structured%20and%20clear%20on%20what%20conditions%20lead%20to%20what%20consequences.%20It%20can%20help%20to%20put%20together%20a%20table%2C%20a%20two-dimensional%20matrix%2C%20that%20spells%20things%20out.....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMight%20I%20suggest%20you%20give%20a%20try%20at%20it%20yourself%2C%20in%20Excel%2C%20and%20then%20if%20you%20still%20need%20help%20post%20your%20work-in-progress%20here%20for%20further%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20link%20to%20a%20website%20that%20might%20help%20you%20with%20some%20IF%20and%20IFS%20formulas%20on%20your%20own.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3DIF%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fsearch%3Fquery%3DIF%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is there a way to fill a formula say you type 1 and it fills out True

or 2 and it fills out false

 

Is there a way to make a formula like this row dependent? so for row 2, 1 may mean yes instead of true on row 1

1 Reply

@arthurvico 

 

The general answer to your general question, "Is it possible?" is yes.

 

To be more specific with an actual function or formula, you will need to be more specific in what those conditions are.

 

Excel has a lot of ability handle complex IF.....THEN conditionals, handling multiple conditions, sub-conditions and all. But we the users need to be very structured and clear on what conditions lead to what consequences. It can help to put together a table, a two-dimensional matrix, that spells things out.....

 

Might I suggest you give a try at it yourself, in Excel, and then if you still need help post your work-in-progress here for further suggestions.

 

Here's a link to a website that might help you with some IF and IFS formulas on your own.

https://exceljet.net/search?query=IF