melbwarrior
New Member
- Joined
- Apr 19, 2018
- Messages
- 16
Hi All
Please assist on the below, I am struggling to create a Nested IF statement
Sample Data:
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
What I am looking for is:
If Column A = CC then multiple the number in column C by 2
If Column B = GG then multiple the number in column C by 3
Any other value in column B multiple the column C by 4
Apologies if this is hard to understand
thanks
Please assist on the below, I am struggling to create a Nested IF statement
Sample Data:
A | B | C |
aa | ff | 1 |
bb | gg | 1 |
bb | gg | 5 |
cc | hh | 4 |
aa | hh | 5 |
cc | gg | 6 |
bb | ff | 5 |
cc | ff | 4 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
What I am looking for is:
If Column A = CC then multiple the number in column C by 2
If Column B = GG then multiple the number in column C by 3
Any other value in column B multiple the column C by 4
Apologies if this is hard to understand
thanks