Need some help please
I have this formula but I want to add 2% on the total
={"total";ARRAYFORMULA(IFERROR(VLOOKUP(B2:B,N1:O,2,0)*J2:J*4))}
If I do like this the total is incorrect
={"total";ARRAYFORMULA(IFERROR(VLOOKUP(B2:B,N1:O,2,0)*J2:J*4+2%))}
I have attached a pic to be more clear.
i.e. the total showing is 24.02 but it should be 24.48
Value is 24 + 2% = 24.48