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

[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

[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!

[lovsgms]

Thank you.

[ExcelIsFun]

You are welcome!!

[simabah]

Hello,

On the example for the Income Statement's IF formula for "Net Income" and "Net Loss" how do we include & show the "break-even" point when there is neither a profit nor a loss?

[ExcelIsFun]

If number is A1:

=IF(A1<0,"Net Loss",IF(A1=0,"Break Even","Net Income"))

[simabah]

Thanks!

:D

[thirthyest]

i forgot something from previous classes and i don't remember which one :)

it's about logical tests, you used AND/or in this vid, i wanted to use the if function instead of those so i came up with:

=IF(B30>=B32&(B31>=B33), "extend credit", "no credit") instead of AND

how about the "OR" (nothing i tried worked:)))))

(i believe you show somewhere how to do if you have 2 logical tests with the if function )

[ExcelIsFun]

Use AND function.

Try these videos:

Excel Magic Trick #31 Part 1: IF AND OR functions, logical

or

Highline Excel Class 33: IF AND OR Customer Credit Analysis

[kami645464]

How do you get negative numbers in red and brackets without (I assume) doing any conditional formatting? I tried formatting the cells into accounting or currency, but don't work. Hope for a quick reply as always. Thank you in advance!

[ExcelIsFun]

Dear kami645464 ,

Apply Currency will work:

Ctrl + 1, select Number tab, Select Currency, select red or black parenthesis.

That should do it.

--excelisfun

[chippendails]

hey

at the end when you made the cell green if it was positiv: what do I have to do if I want it blue if it is negative and green if it is positive? how do I enter this 2 things?

[ExcelIsFun]

Dear chippendails ,

Search for and watch these two videos:

YouTubersLoveEx cel#42: Format Negative Numbers

Highline Excel Class 21: Conditional Formatting 12 Examples

--excelisfun

[soulsaver04]

hello excelisfun

ive seen a spreadsheet and im wondering how to do it..

what i saw was a bunch of data inputed and then theres a save button and once save is clicked then everything clears on the template and the data transfers to a table on another spreadsheet.. sorry i have not yet watched all of your videos , so if you made one similiar to this may you please tell me the title of the video..

thanks

[ExcelIsFun]

Dear soulsaver04,

This video shows something like that:

YTLE#89: Relative & Absolute Macro together

and

YTLE#89 part 2: VBA Code for Relative & Absolute Macro

But really, if you want to write VBA code the smartest VBA Excelers are at the Mr Excel Message Board. Here is a video for that:

How To Post Questions At The Mr Excel Message Board

--excelisfun

[oburcrod]

Hi Master Excel is Fun

I am a English learning student, but I already can understand your lessons, in fact, in my work I am known as a advanced excel user, but thanks to your lessons, your lessons are the best way to learn. God bless you and pay you for it.

Regards from Mexicali, Mexico

[ExcelIsFun]

Dear oburcrod ,

I am glad that the video is useful to you!!

--excelisfun

[alonemusic]

what short cut do you use at 17:02 to adjust your zoom to the selection ?

[ExcelIsFun]

Dear alonemusic,

In Excel 2007, the keyboard shortcut to zoom to Selection is:

Alt + W + G.

I use that one eveyday!

--excelisfun