Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

**be04zimm** · 02-01-2024, 06:29 PM

Hi there! I am working on a new prepaid expenses workbook for my company. The formulas are nearly there! The only problem I seem to have is that the total amount being expensed is great than the total of the individual invoice amount.

Example:

The total invoice = $100
# months to expense = 10
Amount per month SHOULD BE = $10/mo for 10 months
Amount my formulas are expenseing = $11/month for 10 months.

The formula is adding an extra payment. This is my first time using Max/Min formulas in this way. I am open to other formula suggestions!!

Thanks so much!

**DJunqueira** · 02-01-2024, 06:55 PM

I don't know exactly how is your month invoice calculated, but I suspect that it is related to the days in row 1, I corrected it, lets see if it fix or please be more specific about where is the cells to correct.

Formula:

=I3-I2+1

Also added +1 in column G

Formula:

=(+E5-D5)+1

I guess that was the problem.

**be04zimm** · 02-02-2024, 05:59 PM

YES!!!! This was the answer!! I missed SUCH a simple fix. Thanks for looking it over! I was so lost in the detail, I forgot to check the simple stuff. YOU ROCK!

**kvsrinivasamurthy** · 02-02-2024, 12:40 AM

Can you explain an example in the file data.

**DJunqueira** · 02-02-2024, 06:15 PM

Tks for the feedback, glad to help.

Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

Re: Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

Re: Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

Re: Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

Re: Prepaid Expense Spreadsheet - Total Amount Expensed > Invoice Total

Thread Information

Users Browsing this Thread

Similar Threads

Dept and Expense Type Match to calculate total amount

Sorting Total by Name amount to equal total profit or loss

[SOLVED] formula to calculate total amount of previous invoice

[SOLVED] Group wise total amount & net total amount in listbox using vba

Need formula to total invoice amount per month and then total per month per client.

how to work out rate based on total time and total amount

[SOLVED] Combine like invoice items into total amount

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions