addition and multiplication...quantity with difference price

[myc]

hi everyone i am new here!
so my problem is between 3 sheets and 2 difference price and quantity...

im trying to get total with price i determinate like that: x= full price x/2 = with helper

so, i dont know how to get it work...

well i dont know too how to explain my problem...

here's my worksheet (exemple)..

[oeldere]

Maybe a little more explaining.

I see an worksheet
Total
Quantite
Prix 2 tables.
Feuil1

What you're up to?

Please post an example with the desired result.

[tigeravatar]

myc,

Welcome to the forum!
How do you determine when to use full price and when to use half price?

[myc]

well...
this will help me know the cash i will get. like a notepad.. so in the "Prix" sheet i have two tables : one without helper and one table with helper. (two different price = 1/2 with helper)
in the Quantite sheet, i will write every trucks, trailers and other cars i am wrapping (sticker). and in the "total sheet" i will get the total of cash i will make. so my problem is i dont know how to get the quantity of truck i make along and how truck i complet with an helper.

Final result: quantity x price = total (quantite x prix = total)

how to determinate the price i will use in the quantity? (without or with an helper)

[tigeravatar]

myc,

I understand all that, but you still haven't explained: When do you use half price vs full price?

[oeldere]

When you use 1 worksheet for input, you will be more flexible to count / sum to value.

You can work with data-validation to prefent faillure.

You can use Vlookup to look up the price.

You can use a helpcel to determine which table (with or without helper) you need.

[myc]

tigeravatar: i would like the determine it with the quantity. like this : 3 trucks 20" = 2 with helper and 1 alone

[tigeravatar]

Is there a pattern? What if there are 4 trucks? What its 18" instead of 20" What about just 1 truck? or 100? What is the underlying logic for when to use which?

[myc]

after each day i will add what i do (1 truck 18", 2 trailers 14", ...)
if i do it with someone i would lie to write it too because i will get less $$ at the end of the month.
it's like a reminder or a summary of what i do and i will know exactly the cash im supose to make.
i would like to make a table of the material cost too after i solve my problem so i will know exactly the profit that I made,.

---------- Post added at 02:06 PM ---------- Previous post was at 01:33 PM ----------

thank you and i will try to do what you say oeldere! Otherwise i will come back here.
If you understand more what i want to do, say me what you know
(sorry for double posting)

[oeldere]

Maybe like this.

See the example.

Bleu is inputcel

Orange is dropdowncell

Yellow is formulacell

Purple is helpcell.

If you have (other) questions, just ask.