टीप : Smart-phone मध्ये screen Rotate केल्यास file accurate दिसेल.
'teaching' of 'class' 'क्लास'ची 'शिकवणी' is Tech Blog. Here you will find all kind of Tech and blogging related content. For example: Computer Educational Topic, Indian Government Service online help tips and Guide or YouTube Tips and Tricks.
Wednesday, December 2, 2020
11 Advance Excel - Index / Index Match Function
टीप : Smart-phone मध्ये screen Rotate केल्यास file accurate दिसेल.
10 Advence Excel - IF OR Function
टीप : Smart-phone मध्ये screen Rotate केल्यास file accurate दिसेल.
05 Advance Excel - Profit and loss
टीप : Smart-phone मध्ये screen Rotate केल्यास file accurate दिसेल.
Advance Excel-Excel-2013
This Topic
PROFIT & LOSS
Format
Sr.no | Customer Name | Item Name | Purchase | Sales | Profit & Loss | Amount of P& L |
Formula
Profit & Loss = If (Sales>Purchase,”profit”, if (E8<D8,”loss”, if(Sales=Purchase,”Nill”))) Enter
E8= Sales
D8= Purchase
Amount of p & l = Sales - Purchase Enter
This is what you need.
-
Here is a list of commonly used short-cut keys that can provide an easier and quicker method of using computer programs: List of basic c...