If Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adiorthotos - 18 Jul 2006 12:42 GMT

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

Reply to this Message

Bondi - 18 Jul 2006 13:09 GMT

> Hello to all,
>
[quoted text clipped - 20 lines]
> Adiorthotos's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36479
> View this thread: http://www.excelforum.com/showthread.php?threadid=562411

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

Reply to this Message

Adiorthotos - 18 Jul 2006 13:31 GMT

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

Regards

Signature

Adiorthotos

Reply to this Message

Bobocat - 19 Jul 2006 17:06 GMT

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?

> Hello to all,
>
[quoted text clipped - 14 lines]
>
> Thanks a lot.

Reply to this Message

Adiorthotos - 20 Jul 2006 13:35 GMT

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 Wrote:

> hi, some question would like to ask first
> at D1, if A1=1 and B1=2 is true, then c1*5% , how about false?
[quoted text clipped - 35 lines]
> > View this thread
> http://www.excelforum.com/showthread.php?threadid=562411

Reply to this Message

Bobocat - 21 Jul 2006 18:21 GMT

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))

> Hello Bobocat,
>
[quoted text clipped - 43 lines]
>> > View this thread:
>> http://www.excelforum.com/showthread.php?threadid=562411

Reply to this Message