I need help with excel, i making an excel worksheet, that has name and constants dependent on it?

Question

what i want to do is that when i type say water in a cell, two answers calculated in a different sheet will appear in two cells and if another name other than water is used in the same cell other constants corrsponding to that name will be placed in the same cells

Answer 1

You want to use an "IF" formula.

The "IF" formula works like this:

=IF(logical_test, value_if_true, value_if_false)

There are three parts of the formula:

The logical test is where you define stuff like whether it is greater than less than, equal to, or not equal to something. Examples:
A5 = 0
A5 <> 0
A5 < C3*B2
The logical test compares things values, cells, etc.

The value if true is the second portion. It's simply is what it states, the value that your cell takes if the comparison is true, otherwise the value if false will appear in the cell that you have the if formula.

To reference cells in other sheets you simply state the sheet name followed by an exclamation point. Example:

If I'm in cell A1 on Sheet1 and I want to reference cell C3 on Sheet2, then I would do it like this:

=Sheet2!C3

If the sheet name has a space in it like "Sheet 2" you have to surround the sheet name with apostrophes like so:

='Sheet 2'!C3

Or to use the IF statement:

=IF('Sheet 2'!C3 = "water", 50, 25)

Text needs such as water needs to be surrounded by quotes when referring to it in a formula otherwise it will think you are trying to refer to a variable called water.

You can also nest several IF statements inside of an IF statement. Like you could use another IF statement for your Value If True. Example:

=IF(Sheet2!C3 = "water", IF(Sheet2!B1 = "salt", "ocean water", "fresh water"), "land")

The hardest thing is making sure you have all of your parethesis in the right place. They are in pairs. And as you are writing it, Excel will highlight the pairs of parethesis that match.

Answer 2

position the cursor the position you would like the total and then you'll click on the formula signal contained in the icon device bar. click in this and that is going to automaticly do the formula for you. or you could type =sum(A1:A16) and this can upload up each and every of the concepts for you. or you could type =sum( then click on the first cellular you need contained in the formula and drag the mouse down highlighting each and every of the cells you require. Then type ) and hit enter. desire this has helped.