muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to make this formula to calculate 2 conditions :
this formula :
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
any help much appreciated..
m.susanto<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC" target="_blank">#CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC" target="_blank">#CCC ;
}
.tableizer-table th {
background-color: <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=104E8B" target="_blank">#104E8B ;
color: <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF" target="_blank">#FFF ;
font-weight: bold;
}
</style>
how to make this formula to calculate 2 conditions :
this formula :
C | D | E | F | G | |
---|---|---|---|---|---|
7 | data entry / given | ||||
8 | TP | TR | TN | ||
9 | 1995 | 2006 | 2017 | ||
10 | |||||
11 | |||||
12 | after formula | ||||
13 | with "TR" | 15 | |||
14 | without "TR" | ? | |||
15 | |||||
16 | if I delete "TR" the result is false shoul be 2017-1995=22 |
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
any help much appreciated..
m.susanto<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC" target="_blank">#CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCC" target="_blank">#CCC ;
}
.tableizer-table th {
background-color: <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=104E8B" target="_blank">#104E8B ;
color: <a href="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFF" target="_blank">#FFF ;
font-weight: bold;
}
</style>
Last edited by a moderator: