Excel help ekak oni

chullahattipadopana

Well-known member
  • Oct 4, 2022
    1,087
    1,149
    113
    Capture565656565.PNG
    meke machanla/// mama differnace gaththa... eka harida? C colum eka thmayii previous year eka, B thmayiii current year eka.... formula eka "=(C17-(B17))/ABS(C17)
     

    AnuradhaRa

    Well-known member
  • Dec 25, 2010
    61,418
    1
    42,501
    113
    B17/C17-1
    meka try karapan. Formula eka dana cell eke format eka % karapan mathaka athuwa
    අහ් එහෙම දානවනං

    =(C17-B17)/C17 විතරක් දුන්නම ඇති.
     
    Last edited: