I have an invoice set up in excel using vlookup. Everything seems to be fine except I noticed that my selling price (cost + %) is out when I sell multiple quantities of certain items. What I've figured out is the selling cost cell (set to currency and 2 decimal places) actually has more then 2 decimal place for some items (ie. $16.37 is actually $16.367). My line total uses the $16.367 instead of the rounded $16.37, therefore my totals are out for the total invoice amount. Is there a way to have Excel use the rounded amounts instead of the expanded amounts? I want the invoice to read 2 X $16.37 = $32.74, not 2 X $16.37 = $32.73 because Excel doesn't account for the rounded up cost!
Any help would be appreciated!
Any help would be appreciated!