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.

 

[oldbrewer]

at present it WILL change prices of old calculations

we can get round that by every day highlighting ALL previous sales and edit,copy,paste special, values

 

[oldbrewer]

what version of excel have you got

on a NEW workbook highlight A1:A3, then insert, name,testname,ok

click on say G1 then highlight A1:A3

does the name appear top left of screen ?

 

[AliGW]

at present it WILL change prices of old calculations

we can get round that by every day highlighting ALL previous sales and edit,copy,paste special, values

There is a nice little macro I got from one of the Excel forums I frequent (I forget which one) that will do this quickly. You can assign it to a button somewhere on your sheet:

Sub ConvertToValues()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "Select range to convert to values:"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
Application.ScreenUpdating = False
For Each Rng In WorkRng
    Rng.Value = Rng.Value
Next
Application.ScreenUpdating = True
End Sub

However, in this case, it may need adapting to convert the entire sheet prior to updating price tables.

 

[tsameti]

what version of excel have you got

on a NEW workbook highlight A1:A3, then insert, name,testname,ok

click on say G1 then highlight A1:A3

does the name appear top left of screen ?

I've got 2007, I could update to 2013, will it make difference, because I dont see buttons you tell me to press.
I created a table A1:A3 and after I highlighted them I didn't notice anything coming up on the screen.

 

[AliGW]

Named ranges are on the Formulas ribbon, not Insert.

 

[oldbrewer]

ty again Ali

 

[tsameti]

what version of excel have you got

on a NEW workbook highlight A1:A3, then insert, name,testname,ok

click on say G1 then highlight A1:A3

does the name appear top left of screen ?

Hey, I found how to change the name of cells.
It did appear on the top left screen.
I'm ready for the next step.

Thank you for your patience Oldbrewer and Ali