If Calculation

[Adiorthotos]

Hello to all,

I´m a new member at the forum. A question that i have,

I want to calculate the following:

Suppose that in cell A1 is number 1, cell B1 is number 2 and cell C1 i
number 100. On cell A2 is number 1, on cell B2 is number 3 and on cel
C2 is 100.
Now i want the calcutation to cell D1 to returns if values on the cell
A1=1 and B1=2 then C1*5%. For the second row if A2=1 and B2=3 the
C2*6%.
As it is a big file i want to make one calculation so when someon
makes copy-paste to do the calculation automatically.

I hope that you can understand me.

Thanks a lot

 

[Bondi]

Hello to all,

I´m a new member at the forum. A question that i have,

I want to calculate the following:

Suppose that in cell A1 is number 1, cell B1 is number 2 and cell C1 is
number 100. On cell A2 is number 1, on cell B2 is number 3 and on cell
C2 is 100.
Now i want the calcutation to cell D1 to returns if values on the cells
A1=1 and B1=2 then C1*5%. For the second row if A2=1 and B2=3 then
C2*6%.
As it is a big file i want to make one calculation so when someone
makes copy-paste to do the calculation automatically.

I hope that you can understand me.

Thanks a lot.

Hi Adiorthotos,

I'm not really sure about your data but if column is always 1 and there
is only the possibility of column B to be 2 or 3 then you can use
something like:

=IF(B1=2,C1*1.05,C1*1.06)

If column A and B can contain different values then maybe you can use
something like:

=IF(AND(A5=1,B5=2),C5*1.05,IF(AND(A5=1,B5=3),C5*1.06,C5))

And this will return the original content of column c if the conditions
are not met.

Regards,
Bondi

 

[Adiorthotos]

Thank you for yr reply but i´m afraim it is incorrect. By the way the
3DIF is some typing mistake?

Regards

 

[Bobocat]

hi, some question would like to ask first
at D1, if A1=1 and B1=2 is true, then c1*5% , how about false?
at next row
suppose D2, if A2=1 and B2=3 is true, then c2*6%, how about false?
what happen the third row?
if A3=1 and B3=4 is true?, then c3*7%? and so on?

"Adiorthotos" <[email protected]>
wrote in message
news:[email protected]...

 

[Adiorthotos]

Hello Bobocat,

Values at cells are true, i just want a formula to take the values o
each cell and calculate for each occasion separate. 5% or 6%.

Thanks for yr help.

 

[Bobocat]

to my understand
when col A=1, col B=2, then col C*5% or col A=1, colB=3, then colC*6%, if
the above is false, no calculation or 0 is display

=IF(AND(A1=1,B1=2),C1*5%,IF(AND(A1=1,B1=3),C1*6%,0))


"Adiorthotos" <[email protected]>
wrote in message