mrsadventure
New Member
- Joined
- Mar 22, 2019
- Messages
- 1
I am in desperate need of help. I am a novice at excel formulas. I need to write a formula that will pull from a set of data the separates between a Male or Female, Number of Push Ups and then provides a score...so for example:
<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</tbody>
So if I am in a new spreadsheet, first column (A) would say M or F, then I will enter data in column (B) then I need Column C to show the corresponding answer, for example
<tbody>
</tbody>
<tbody>
</tbody>
M | F | ||
Push Ups | Score | Push Ups | Score |
36 | 52 | 36 | 90 |
35 | 50 | 35 | 88 |
34 | 49 | 34 | 86 |
33 | 48 | 33 | 84 |
32 | 46 | 32 | 83 |
31 | 45 | 31 | 81 |
30 | 43 | 30 | 79 |
29 | 42 | 29 | 77 |
<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</tbody>
So if I am in a new spreadsheet, first column (A) would say M or F, then I will enter data in column (B) then I need Column C to show the corresponding answer, for example
<tbody>
</tbody>
A | B | C |
M | 36 | using the data above should calculate and show "52" |
F | 30 | using the data above should calculate and show "79" |
<tbody>
</tbody>