Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you do 'if' statements?
On sheet 1, column B, Line 27, I have to enter 'M' or 'F'.
On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
#2
|
|||
|
|||
What do you mean by:
I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. What form does the health rate take? Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
#3
|
|||
|
|||
I need on sheet 1, column C, to populate the health rate based on column B
line 26 and column B line 27 (the sex and age of the applicant). The health rate chart is on sheet 3. Does that make any more sense? "Sandy Mann" wrote: What do you mean by: I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. What form does the health rate take? Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
#4
|
|||
|
|||
Hi Angie,
It may make more sense to someone else but I'm afraid that it still leaves me wondering (ie I don't know what a *health rate* is). You say that you want to populate column C with the "health rate" and that the health rate chart is on sheet 3. The use of a word *chart* makes me think of a graph, is it a graph on sheet 3? Is it data items that you want populated, (entered?) in column C? If so do they come from a table of data in sheet 3 rather than a chart? If so how is the table laid out? If it helps you can send me a sample workbook, just follow the instructions under my signature. (But it getting fairly late at night here so I will possibly not reply until tomorrow). Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... I need on sheet 1, column C, to populate the health rate based on column B line 26 and column B line 27 (the sex and age of the applicant). The health rate chart is on sheet 3. Does that make any more sense? "Sandy Mann" wrote: What do you mean by: I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. What form does the health rate take? Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
#5
|
|||
|
|||
I believe I need a Sumproduct formula...do you know how to do those?
"Sandy Mann" wrote: What do you mean by: I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. What form does the health rate take? Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
#6
|
|||
|
|||
Hi Angie,
For SUMPRODUCT try: http://www.xldynamic.com/source/xld.SUMPRODUCT.html But don't you mean VLOOKUP? if so try the Excel Help files HTH Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... I believe I need a Sumproduct formula...do you know how to do those? "Sandy Mann" wrote: What do you mean by: I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. What form does the health rate take? Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "angie" wrote in message ... On sheet 1, column B, Line 27, I have to enter 'M' or 'F'. On sheet 1, column B, Line 28, I enter an age. '54'. I need on sheet 1, column C, to populate the health rate based on the criteria entered, 'M/F' and 'age'. The health rates are on sheet 3. Does this make sense? Can anyone help me? I am still learning this program. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
Working with If statements and time | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |