Highline Excel Class 11: Logical formulas, IS & IF functions

Learn about:
1.Comparative Operators
2.Logical TRUE FALSE formulas
3.IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT)
4.IF function (1 of 2 words in a cell, 1 of 2 numbers in a cell, 1 of 2 formulas in a cell)
5.Conditional Formatting TRUE FALSE formula

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• Logical
• TRUE
• FALSE
• formulas
• IS
• IF
• functions
• ISTEXT
• ISNUMBER
• ISERROR
• conditional
• formatting
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[aman1245singh]

Thanks for the wonderful video and the answer to my query posted in the previous video again. :)

I wanted to ask that -

How to we go to the point mode from the edit mode while editing the cell or entering formula(e) in it? the shortcut is what I am looking for :)

Thanks in advance

[ExcelIsFun]

F2 key.

[pinkyme86]

what excel formula should I use which will count phrases in first column and will display two word phrases in 2nd column (if a row in 1st column contains two word phrases) and will display the word "ERROR" if a row in 1st column contains 1, 3 or more phrases?

[ExcelIsFun]

I do not know. Try the Mr Excel Message Board:

mrexcel[dot]com/forum

[WEIRDOinPANTS]

I love these classes! They are awesome!

[ExcelIsFun]

I am glad that thet are helpful!

[prudhvirajreddyable]

excellent buddy

[MrJonmuir]

Hi,

Great videos, you just saved me about an hour in my accounts prep withe the off statement on the text fields.

In the current us/ Uk GAAP and IFRS accounting standards it is acceptable to have a negative number in brackets we no longer have a positive number for a loss.

Thanks for the tips

J