IF Statement and Nested IF Statement in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
26,293
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 19, 2008

http://www.TeachMsOffice.com
How to use a basic IF statement in Excel and also how to use a nested IF statement in Excel. This is a good tutorial for a beginner and also someone looking to understand nested IF statements.


http://www.TeachMsOffice.com

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelisHell)

  • Can I do "if" and "or" statements when it comes to words. For example: If they choose (froma drop down list) XL (a shirt size rather than small), could I make it say: "Please give measurements"? Thanks

    WOL

  • @wayoflight Yea, that sounds like it should work.  Just try it out, and if it doesn't work, check out teachmsoffice. com for all of my tutorials on logical statements.

  • I have tried doing that, after i have hit on enter the formula still remains....whats wrong?...

  • It's hard to tell. If you could provide a more thorough explanation of what you did I might be able to determine what went wrong. You can private message me on here if you like.

see all

All Comments (14)

Sign In or Sign Up now to post a comment!
  • Loved the Way You Explained It, Simple and Straight To The Point.... 10 Thumbs Up Guy!!!

  • JEEEZ, I've had a massive problem with my spreadsheet, until I saw this. Thanks SOOOOOO much!!!!

  • How do I write a command which will say the following. If a cell is greater than zero move down one row, if not delete row.

  • Brilliant. So clear and simple. Thank you. xxx

  • how do u make it more than or equal to a selected data list

  • thanx a bunch fo the help...:)

  • @ExcelisHell I have figured out my mistake and all is good. thanks anywayz.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more