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 दिसेल.

08 Advance Excel -

   टीप : Smart-phone मध्ये  screen Rotate केल्यास file accurate दिसेल.

07 Advance Excel - Define Name

   टीप : Smart-phone मध्ये  screen Rotate केल्यास file accurate दिसेल.

06 Advance Excel - Mark Sheet

  टीप : 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