टीप : 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
No comments:
Post a Comment
Please do not enter ant spam link in the comment box.