Changing formula in an invoice.

  • Thread starter Thread starter Auntie Annette House MO
  • Start date Start date
A

Auntie Annette House MO

I have an invoice that has a formula for taxes and I need to change it to subtract a discount in the space above to give a discount of $5.00 per person and the space below it to subtract the deposit of however much has been sent in and then totaled on the following space. Can any one give me the formulas? The space above the discount space is the sub- total.
What is this formula for?
-- =IF(L$35>0,IF(dflt6,IF(vital5=data8,L$35*dflt5,""),IF(dflt5>0,L$35*dflt5,"")),"")
 
-- I really need help with this. If you can't help do you know where I can get help???
I have an invoice that has a formula for taxes and I need to change it to subtract a discount in the space above to give a discount of $5.00 per person and the space below it to subtract the deposit of however much has been sent in and then totaled on the following space. Can any one give me the formulas? The space above the discount space is the sub- total.
What is this formula for?
-- =IF(L$35>0,IF(dflt6,IF(vital5=data8,L$35*dflt5,""),IF(dflt5>0,L$35*dflt5,"")),"")
 
First, this is pretty much a plain text newsgroup. So you may want to turn off
that HTML formatting for your next post.

(Plain text is easier to read when reach a certain age <bg>.)

This formula is using some defined names.

=IF(L$35>0,IF(dflt6,IF(vital5=data8,L$35*dflt5,""),IF(dflt5>0,L$35*dflt5,"")),"")

They could refer to either a cell on a worksheet (any old worksheet in your
workbook) or they could refer to a value.

I think the easiest way to see what these things refer to is to get a copy ofJan
Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Then you can open that workbook and see what each of those things points to.
 
The reason you haven't received an answer is most likely that your question
is
impossible to comprehend as written. If there is a formula solution I am
sure
there are many here that can help but frankly your question does not make
any sense?
Is the posted formula for taxes? What is space above, L$34? Where would you
find
the number of people (per person)? Rephrase your question with more
explanations
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



-- I really need help with this. If you can't help do you know where I can
get help???
I have an invoice that has a formula for taxes and I need to change it to
subtract a discount in the space above to give a discount of $5.00 per
person and the space below it to subtract the deposit of however much has
been sent in and then totaled on the following space. Can any one give me
the formulas? The space above the discount space is the sub- total.
What is this formula for?
 
Am I able to send an attachment on this group? If so I could show you what
I am talking about.

-- I really need help with this. If you can't help do you know where I can
get help???
I have an invoice that has a formula for taxes and I need to change it to
subtract a discount in the space above to give a discount of $5.00 per
person and the space below it to subtract the deposit of however much has
been sent in and then totaled on the following space. Can any one give me
the formulas? The space above the discount space is the sub- total.
What is this formula for?
 
Please don't send an attachment. Someone will ask if they want you to
send one via email.

In the mean time, your original post was very confusing to someone who
is not looking at your spreadsheet. Perhaps restating the problem, using
cell references, formulas, etc., would be more helpful.

See http://cpearson.com/excel/newposte.htm for tips on using these
groups effectively.
 
I am really green and don't know what the formula should be. I will try to
do it later. Thanks.
 
Auntie

Sounds like you are using INVOICE.XLT from Spreadsheet Solutions.

The

=IF(L$35>0,IF(dflt6,IF(vital5=data8,L$35*dflt5,""),IF(dflt5>0,L$35*dflt5,"")),"")

Formula is in the City Taxes cell, right?

Above that you have State Taxes and below you have Total, right?

The dflt5 and dflt6 are named cells which you can see at Insert>Name>Define.

Do you want to insert a new row above City Taxes with the discount of $5.00
and have this subtracted from the Total?

Where does the "deposit" come in?

I think we can get you sorted if this is the Invoice template you're using.

Gord Dibben Excel MVP
 
Yes that is correct. But I need them to be discount of $5 in the tax and in
the other one I need to have deposit and both to subtract from subtotal then
figure out a total.
 
Back
Top