Showing posts with label sum function. Show all posts
Showing posts with label sum 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