Invoice template total column formula

[Lilgnomey]

I have an invoice spreadsheet that I've made up which is pretty automatic, using a VLOOKUP, but I've just had to modify the totals column so that it does something different if a certain item number is selected. I have this formula in the 'total price' column:

=IF(ISBLANK(B17),"",IF(B17="6",A17*D17,(A17/$A$14)*VLOOKUP(B17,Item,3)))

The formula works ok, no errors, except that if the item number is 6, the formula still uses $A$14 (which has the number 350) to divide it, but in that single instance I don't want it to; I just want the straight 'A17*D17' equation. I'm SURE it's something simple, but I just can't see it. Need fresh input.

I hope this is reasonably clear. Am fairly much a learner so go easy on me

[TMS]

You have "6" in quotes which makes it a text string and different to the numeric value 6. Remove the quotes.


Regards, TMS

[Lilgnomey]

Thank you so much! I knew it would be something simple, but I thought that I would have to define it as a text value to make it recognise the number. Greatly appreciate your help

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.