Multiple Ifs with Calculations

[melbwarrior]

Hi All

Please assist on the below, I am struggling to create a Nested IF statement


Sample Data:

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"]A[/TD]
[TD="class: xl66, width: 64"]B[/TD]
[TD="class: xl66, width: 64"]C[/TD]
[/TR]
[TR]
[TD="class: xl67"]aa[/TD]
[TD="class: xl67"]ff[/TD]
[TD="class: xl69"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]bb[/TD]
[TD="class: xl67"]gg[/TD]
[TD="class: xl69"]1[/TD]
[/TR]
[TR]
[TD="class: xl67"]bb[/TD]
[TD="class: xl67"]gg[/TD]
[TD="class: xl69"]5[/TD]
[/TR]
[TR]
[TD="class: xl68"]cc[/TD]
[TD="class: xl68"]hh[/TD]
[TD="class: xl69"]4[/TD]
[/TR]
[TR]
[TD="class: xl67"]aa[/TD]
[TD="class: xl68"]hh[/TD]
[TD="class: xl69"]5[/TD]
[/TR]
[TR]
[TD="class: xl68"]cc[/TD]
[TD="class: xl67"]gg[/TD]
[TD="class: xl69"]6[/TD]
[/TR]
[TR]
[TD="class: xl67"]bb[/TD]
[TD="class: xl67"]ff[/TD]
[TD="class: xl69"]5[/TD]
[/TR]
[TR]
[TD="class: xl68"]cc[/TD]
[TD="class: xl67"]ff[/TD]
[TD="class: xl69"]4[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[Peter_SSs]

Hint for next time: When you give sample data, also giving the expected results usually helps clarify your requirements.

Is this what you want?

Excel Workbook
	A	B	C	D
1
2	aa	ff	1	4
3	bb	gg	1	3
4	bb	gg	5	15
5	cc	hh	4	8
6	aa	hh	5	20
7	cc	gg	6	12
8	bb	ff	5	20
9	cc	ff	4	8
IF

 

[melbwarrior]

Hi

Sorry for the delay in getting back to you.

That looks good - I have one more question if that is ok.


[TABLE="class: cms_table, width: 192"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 64"]A[/TD]
[TD="class: cms_table_xl66, width: 64"]B[/TD]
[TD="class: cms_table_xl66, width: 64"]C[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]aa[/TD]
[TD="class: cms_table_xl67"]ff[/TD]
[TD="class: cms_table_xl69"]1[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]bb[/TD]
[TD="class: cms_table_xl67"]gg1[/TD]
[TD="class: cms_table_xl69"]1[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]bb[/TD]
[TD="class: cms_table_xl67"]gg23[/TD]
[TD="class: cms_table_xl69"]5[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl68"]cc[/TD]
[TD="class: cms_table_xl68"]hh[/TD]
[TD="class: cms_table_xl69"]4[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]aa[/TD]
[TD="class: cms_table_xl68"]hh[/TD]
[TD="class: cms_table_xl69"]5[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl68"]cc[/TD]
[TD="class: cms_table_xl67"]gg32[/TD]
[TD="class: cms_table_xl69"]6[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67"]bb[/TD]
[TD="class: cms_table_xl67"]ff[/TD]
[TD="class: cms_table_xl69"]5[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl68"]cc[/TD]
[TD="class: cms_table_xl67"]ff[/TD]
[TD="class: cms_table_xl69"]4[/TD]
[/TR]
</tbody>[/TABLE]

Could the formula be modified to make the same calculation in Column B for GG, if there a few difference occurences - as per above. (gg1, gg3,gg32). The calculation would still be the same as the previous formula

I can't figure out how to introduce the Find left function into the formula

again thanks for your help

 

[Peter_SSs]

Try
=C2*IF(A2="cc",2,IF(LEFT(B2,2)="gg",3,4))

 

[melbwarrior]

That works perfectly

Thank you very much

 

[Peter_SSs]

That works perfectly

Thank you very much

You’re welcome.