Cash register spreadsheet

[tsameti]

First of all apologize if this is not the right place to ask for this sort of help.
Can anyone help creating this simple spreadsheet.
I have created one myself but I can make it work just the way I want it.
In the end I had to simplify it to the point where I enter almost all data except for calculation and even that stops if the item number is higher than 2.


=IF(B35=1,B35*27.5,IF(B35=2,B35*27.5))
This is as far as I went and I cant make graphics work either, as for now I simply change color on Item QTY manualy to know what was sold.

 

[tsameti]

in G1 to G3 put green, red yellow
in H1 to H3 put 75,34,22
highlight G1:H3
insert,name,mytable
in A1 put red
in a2 put =vlookup(a1,mytable 2)
you should see 34

report success and I will guide you through more steps to develop what you want

MODERATORS - can I send the OP a kind of blueprint spreadsheet please ?

When I press right button theres nothing like INSERT>NAME>MYTABLE.
I can only do this from the top menu INSERT>TABLE>CREATE TABLE>WHERE IS DATA FOR YOUR TABLE>OK>RENAME TABLE

In the end error comes up, I tried removing 2 in the end of the formula but still an error.

 

[AliGW]

The formula is missing a comma:

=VLOOKUP(A1,mytable,2)

 

[oldbrewer]

good morning, Ali !

ooops It was me who missed out the comma

tsameti - why dropdowns on the table ?

 

[AliGW]

Morning, Sir!

 

[tsameti]

good morning, Ali !

ooops It was me who missed out the comma

tsameti - why dropdowns on the table ?

Hooray!
We did it. It worked and I got 34.

I only know one way to create TABLE.
INSERT>TABLE
It creates drop downs automatically. Tried to google how to remove drop down in the table but couldn't do it.

I found this drop down list, which I think is a good idea however you need to use mouse to select the item.

 

[AliGW]

Glad to have helped!

 

[oldbrewer]

ok now insert name mytable delete to temporarily lose references to table

now highlight the table as before but down to row 10

insert name define mytable

now add pen and pencil on rows 4 and 5 with a price

now put pencil in the "lookup" cell

what do you get ?

 

[tsameti]

ok now insert name mytable delete to temporarily lose references to table

now highlight the table as before but down to row 10

insert name define mytable

now add pen and pencil on rows 4 and 5 with a price

now put pencil in the "lookup" cell

what do you get ?

I couldn't rename to mytable so I left it table11.
Where do I put pencil lookup? In which cell?

 

[oldbrewer]

in E3 with 2 at end of look up
in F3 with 3 at wnd of lookup

 

[tsameti]

in E3 with 2 at end of look up
in F3 with 3 at wnd of lookup

=VLOOKUP(C3,Table11,2)
=VLOOKUP(C3,Table11,3)
=D3*E3-F3*D3

item	how many	sale price	cost price	profit
pen	2
pencil	1	0.35	0.1	0.25
ruler	2	0.75	0.3	0.9
pen	2	2.25	1.1	2.3
pencil	1	0.35	0.1	0.25
string	3	0.99	0.35	1.92

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

item	how many	sale price	cost price	profit
pen	2
pencil	1	0.35	0.1	0.25
ruler	2	0.75	0.3	0.9
pen	2	2.25	1.1	2.3
pencil	1	0.35	0.1	0.25
string	3	0.99	0.35	1.92

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

I think it works, however every time I change price in the table it changes prices of old calculations. I believe there's other way than just creating a new table every time I need to adjust cost price and selling price.