Excel වැඩ්ඩො එන්න

[pra52]

Mekai wenna ona

Amount list ekak thiyanwa,eke pahala tyana widihta rate eka apply wennaformular ekak danna ona

Eg: 4,500,000

First 1000,000 ta 18%
1,000,001 - 2,999,999ta 10%
3,000,000 ta wadi nam 8%

Me ranges 3 apply wena fomulars ...

 

[Pink panther]

 

[Hora_Nariya]

BUMP​

 

[dmudhitha]

 

[youtube]

Mekai wenna ona

Amount list ekak thiyanwa,eke pahala tyana widihta rate eka apply wennaformular ekak danna ona

Eg: 4,500,000

First 1000,000 ta 18%
1,000,001 - 2,999,999ta 10%
3,000,000 ta wadi nam 8%

Me ranges 3 apply wena fomulars ...

Meka try karapan
=IF(Cell#<1000000,Cell#*18%, IF(Cell#<2999999,Cell#*10%,Cell#*5%))

Oya Cell# kiyanne ubage original value eka thiyana cell eke # eka. pas polatama ekama cell # ekak enda one.

 

[LOL_SEEN]

මම උබට හෙල්ප් කරනවා, උබ වෙන අයට හෙල්ප් කල post 3ක් පෙන්නුවොත්