Here are some problems that our users have asked and received explanations on
I need a formula to adjust price after a % of increase or decrease to base price is provided
and after that occurs a formula to total invoice
Solved by T. L. in 13 mins
i want to make formula in invoice number and make a one invoice number and remove duplicates
Solved by V. H. in 23 mins
I'm trying to write a formula that will return the value of the Net Invoice Amount ('Invoice Data'!D) if the Account IDs (Calculations!F, 'Invoice Data'!A) and Billing Periods (Calculations!G1:V1, Invoice Data!C) match.
Solved by E. H. in 29 mins
I need a formula to transpose data sets from rows to columns by matching Example
Invoice#1|Product1ID|Product1Description
Invoice#1|Product2ID|Product2Description
Invoice#1|Product3ID|Product3Description
Invoice#2|Product1ID|Product1Description
Invoice#3|Product1ID|Product1Description
Invoice#3|Product2ID|Product2Description
I would want a column for Product1ID and Product1Description and so on.
Solved by F. A. in 22 mins
how do you create invoice number that will automatically update itself everytime you open the invoice, what is the formula ?