Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel IF Function

0

How do I make a logical precedence example for the "If" function excel's into consideration when evaluating multiple if-then statements? How do you simulate a formula as an if-then statement in Excel? Plz recommend me some resource for Excel If function in detail. I've got a lot good info from this resource but want to read more.

https://www.exceltrick.com/formulas_macros/excel-if-statement/
excel
posted by: zacharyswift727 on Thu Jul 29, 2021 at 5:55 am
Answer
Discuss

Discussion

Multiple IF statements can often be replaced with a single INDEX/MATCH function. Therefore I suggest you forget about learning everything about IF statements. You will have more fun learning Excel if you stipulate a problem and find the best solution for it. 
Variatus (rep: 4889) Jul 29, '21 at 10:31 pm
Add to Discussion

Answers

0

Zachary

Your link shows that the IF function is <<test>> , << value if true>>, << value if false>> which is akin to << If decision/test>> , <<  Then (value if true)>>, << Else (value if false)>>.

Suggest you try Don's tutorial 15 IF Statement Examples in Excel or search for others on the Excel Tutorials page of this site.

posted by: John_Ru (rep: 6142) on Thu Jul 29, 2021 at 11:38 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login