!Best Excel Trick to Calculate GST Reverse Charge Mechanism(RCM) in Excel ! #excel #shorts #ytshorts
!Best Excel Trick to Calculate GST Reverse Charge Mechanism(RCM) in Excel ! #excel #shorts #ytshorts
FORMULA:
GST AMOUNT: =IF(D3="YES",B3*C3/100,0)
TOTAL PRICE: =B3+E3
Total GST for Reverse Charge: =SUMIF(D3,"YES",E3)
Change cells according to your data.
#computer
#exceltricks
#computertricks
#computer
#youtubeshorts
#ytshorts
#msexcel
#microsoftexcel
#msexcel
#excelclub
#excelclasses
#exceleducation #exceltech
Видео !Best Excel Trick to Calculate GST Reverse Charge Mechanism(RCM) in Excel ! #excel #shorts #ytshorts канала Tech Table Tutor
FORMULA:
GST AMOUNT: =IF(D3="YES",B3*C3/100,0)
TOTAL PRICE: =B3+E3
Total GST for Reverse Charge: =SUMIF(D3,"YES",E3)
Change cells according to your data.
#computer
#exceltricks
#computertricks
#computer
#youtubeshorts
#ytshorts
#msexcel
#microsoftexcel
#msexcel
#excelclub
#excelclasses
#exceleducation #exceltech
Видео !Best Excel Trick to Calculate GST Reverse Charge Mechanism(RCM) in Excel ! #excel #shorts #ytshorts канала Tech Table Tutor
Комментарии отсутствуют
Информация о видео
30 августа 2024 г. 12:30:11
00:00:37
Другие видео канала