Multiple Ifs with Calculations

[melbwarrior]

Hi All

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

 

[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.

A	B	C
aa	ff	1
bb	gg1	1
bb	gg23	5
cc	hh	4
aa	hh	5
cc	gg32	6
bb	ff	5
cc	ff	4

<tbody>
</tbody>

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.