Showing posts with label if function. Show all posts
Showing posts with label if function. Show all posts

HOW TO USE IF FORMULA USING WITH COUNT, COUNTIFS AND SUM FORMULA


How To Use If Function With Count Function, Sum Function And Countifs Function

IF FORMULA

If formula is most useful and helpful formula in Microsoft Excel. This Formula Allow you to make logical comparison between two values. 

Say If Formula is:

IF(Something is True, then Do Something, Otherwise Do Something Else)


Introduce this Article

In this article we have cover 4 Different Example About If Function With 3 More Different Function, 


EXAMPLE 1:

Example 1 is commission computation. we have sale amount and target amount (Show in Picture). IF Target Amount is Greater then Sale amount. 5% Commission Allow on Excess Of Target Amount


Sales Commission Computation Using If Function


HOW TO DATE CONSOLIDATE 2 TABLE IN ONE

3 MORE EXAMPLES MUST WATCH VIDEO


HOW TO USE IF FUNCTION WITH "AND OR NOT" FUNCTIONS

HOW TO USE IF FUNCTION WITH AND OR NOT FUNCTION


How to use "IF" function with "And / Or / Not" functions in excel

IF Function In Excel

if function in excel 2013
=IF(C4>=$C$1,"Allow","Not Allow")

In this Example picture defines us to when salesperson Achieved target to Allow Bonus Otherwise Not Allow. if c4 cell value is 460,027 and target value is 500,000 in cell c1. if c4 greater than or equal to c1 result True if the value is true if a function is shown result "Allow" if the value is false shown result "Not Allow"

And Function In Excel With IF Function


And function in excel

=IF(AND(C15>=$C$11,D15>$C$12),"Allow","Not Allow")

in the picture use "AND" function. "AND" function is very useful logical_test Function in Excel. In this function all arguments evaluate is true result is True. One and more than one arguments evaluate is false result is False.

=And(Logical1, Logical2....)
=And(True, True, True) = "True"
=And(True,True,False) = "False" 

Or Function In Excel with If Function

Or function in excel www.coursedots.com

=IF(OR(C25>=$C$21,D25>$C$22),"Allow","Not Allow")

in the picture use "OR" function. "OR" function is very useful logical_test Function in Excel. In this function one and more than one arguments evaluate is True result is True.

=Or(Logical1, Logical2....)
=Or(True, True, True) = "True"
=Or(True,True,False) = "True"
=Or(False,False,False) = "False"

Not Function Use With if Conditions


not function use in excel www.coursedots.com

=IF(NOT(AND(C35>=$C$31,D35>$C$32)),"Not Allow","Allow")

In the picture use "NOT" Function. "NOT" Function Reverses your Result. that mean True Value convert in False and False value convert in True. Not function use when you want to make sure a value is not equal to one particular value.

Video

 

Download Sample File Click Here

you have any idea about Excel, blogger., WordPress, photoshop, Seo Experts, other like this simply create your own article and submit your own post. your post will publish as soon on www.coursedots.com