[Propos]

2 quick questions.

1) Why when I put '-£209.43' into a cell it changes to '-£209'. I want it to read exactly as the value I entered. It has nothing to do with the '-' because in other cells it has entered the full value as I put it in regardless of '-' or not.

2) Where do you create the formula(s)? For instance I want to be able to put 2 numbers in 2 different cells - which automatically put a value into a 3rd cell without me having to calculate it. I also want to do the same whereby a value is automatically entered once 5% has been deducted. Is this possible?

Thanks.

[OU Student]

(Original post by Propos)
2 quick questions.

1) Why when I put '-£209.43' into a cell it changes to '-£209'. I want it to read exactly as the value I entered. It has nothing to do with the '-' because in other cells it has entered the full value as I put it in regardless of '-' or not.

Right click on the cell and select format cells. You may need to change it to 2 decimal places. Or it might be the cell size.

2) Where do you create the formula(s)? For instance I want to be able to put 2 numbers in 2 different cells - which automatically put a value into a 3rd cell without me having to calculate it. I also want to do the same whereby a value is automatically entered once 5% has been deducted. Is this possible?

Thanks.

In the first cell, you type the formula. This should always start with =(formula) and then you should be able to drag the cells and it copies and pastes the formula.

[Repressor]

For official documentation with the first problem.
https://office.microsoft.com/en-us/e...005241205.aspx

If you put what you want to happen to the two numbers. I'm sure someone will give you the formulae. For your second one you'd probably want =0.95*A1, for example.

[userna-me*]

(Original post by Propos)
2 quick questions.

1) Why when I put '-£209.43' into a cell it changes to '-£209'. I want it to read exactly as the value I entered. It has nothing to do with the '-' because in other cells it has entered the full value as I put it in regardless of '-' or not.

2) Where do you create the formula(s)? For instance I want to be able to put 2 numbers in 2 different cells - which automatically put a value into a 3rd cell without me having to calculate it. I also want to do the same whereby a value is automatically entered once 5% has been deducted. Is this possible?

Thanks.

1) You're being tricked into formatting, so you need to change that. (Ctrl+1 is the keyboard shortcut for number formatting)

2) You need a range to select from. e.g. 100 and 100. You want to find the sum ('alt'+'=' is the keyboard shortcut for auto sum) then highlight the cells you want to input. Your formula will then automatically look up the values you have highlighted.