Excel Logic Functions - IF, AND, and OR

Using a combination of IF, AND, and OR functions to determine employee pay and bonuses.

Category:

Education

Tags:

• excel
• function
• functions
• and
• if
• or
• logic

[Careegar]

splendid ... a true teacher of excel

[mariam88able]

amazing just what i was searching for thx :))

[CENTAURSARATOGA]

Superb Teacher !!! I'm finally getting the hang of it........BRAVO !!!

[chowman007]

Good Morning Phillips, here's my dilema. am creating a worksheet that auto populates employee breaks upon entering start and hours worked. Shifts >=10 will get 2 breaks and lunch every 2.5 hrs. <=5 hrs worked will get 1 break only every 2 hrs. shifts of 5.5 to 8 hrs get 2 breaks 1 lunch every 2 hrs. Now, I have 20 employees of which I may have 4 starting at the same time, so I will schedule them in an increment of 15mins. Hope you can guide.

[shiploo2010]

Goshh! You are a life saver!!! ;)

[mortalkombatmm]

wow, In this light, you're stunning

[pen567tinio]

When using the right mouse key to lock the figures- can you reverse the function so that you can edit the figures??

Otherwise brilliant videos great help with SAGE level 2 Excel

[azeesulaman]

i have problem with my company comsion

if stock rate is 1 to 50 then commision (0.05) , more then 50 (0.10) more 100 (0.15) 150(0.20) 200 (0.25)

proble acourd in if condiotion there is only two condition but i faced more then 5 how i apply formula please help

[tirathmistry]

Excellent tutorials with superb example

Thanks so much for posting it

keep up good work

God bless you :-)

[davidnee]

i learned stuff even from the set up - what program are you using to record your screen?