RANREV INFOTECH Invoice Bill In Excel Part 2
Author: Sanskriti
Show #N/A Value
For Remove #N/A Value Iferror formula
Formula =IFERROR(Vlookup(celladdress of particular lock by F4,celladdress of table lock by F4,column no 2 of amount,0),””)
Multiplication of total amount
For remove #value IFERROR
|
TOTAL |
=SUM(CELLADDRESS ALL TOTAL) |
|
CGST |
=CELLADDRESSTOTAL*8% |
|
SGST |
=CELLADDRESSTOTAL*8% |
|
GRAND TOTAL |
=TOTAL+CGST+SGST |
Invoice Bill
