Easy Office
LCI Learning

How to get information by using formula

This query is : Resolved 

09 August 2010
Let me present here a summarized worksheet

Supp Name Item Des Value VAT rate Vat amt
Asha Entp 775 4 31
Asha Entp 3415 12.5 426.88

09 August 2010 LET TAKES
COLUMN A : SUPPLIER NAME
COLUMN B : ITEM DESCRIPTION
COLUMN C : VALUE OF PARTICULAR ITEM COLUMN D : VAT RATE ( FEED RATE MANUALLY)
COLUMN E : VAT VALUE ( IN THIS ROW/COLUMN
= C2*D2/100
ASSUMING ROW 1 IS USED FOR DESCIRIPTION OF COLUMN HEADING AND DATA IS FEEDING IN ROW 2.



You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query