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>
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: center"]data entry / given[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: center"]TP[/TD]
[TD="align: center"]TR[/TD]
[TD="align: center"]TN[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1995[/TD]
[TD="align: right"]2006[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"][/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: <a href="]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: <a href="]D13[/TH]
[TD="align: left"]=ROUND(((F9-D9)+2*(F9-E9))/3,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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 | |
---|---|---|---|---|---|
after formula | |||||
with "TR" | |||||
without "TR" | ? | ||||
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>
[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: center"]data entry / given[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: center"]TP[/TD]
[TD="align: center"]TR[/TD]
[TD="align: center"]TN[/TD]
[TD="align: right"][/TD]
[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1995[/TD]
[TD="align: right"]2006[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"][/TD]
[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>
Sheet1
[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: <a href="]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: <a href="]D13[/TH]
[TD="align: left"]=ROUND(((F9-D9)+2*(F9-E9))/3,0)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
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: