asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Goog Day,
On cell C41 I want to put a formula which will calculate the total sum with the conditions below.
I've created a table from B6:D40
There will be numbers from B6:B40 and C6:D40 will have the letter info as X
My target is to get the total of those numbers.But if there is no info on column C as X
If there is info as X then that number will be reduce %5 from the original amount(if 100000 will consider 95000!)Many thanks.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
On cell C41 I want to put a formula which will calculate the total sum with the conditions below.
I've created a table from B6:D40
There will be numbers from B6:B40 and C6:D40 will have the letter info as X
My target is to get the total of those numbers.But if there is no info on column C as X
If there is info as X then that number will be reduce %5 from the original amount(if 100000 will consider 95000!)Many thanks.
5% | - | |
COLUMN B | COLUMN C | COLUMN D |
20,000 | X | |
45,000 | X | |
50,000 | X | |
100,000 | X | |
300,000 | X | |
TOTAL: | 506,500 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>