If equations

[Guest]

Column A will have values either cd, dvd, lp. Column B has dollar values. I would like to have an equation that says if A2 says cd, then D2 equals B2 or IF A2 says dvd, then E2 equals B2 or IF A2 says lp, then F2 equals B2. How state the equation for it to do this?

 

[Peo Sjoblom]

You would need 3 different formulas, in D2 put

=IF(A2="cd",B2,"")

in E2

=IF(A2="dvd",B2,"")

in F2

=IF(A2="lp",B2,"")

--

Regards,

Peo Sjoblom

Column A will have values either cd, dvd, lp. Column B has dollar values.

I would like to have an equation that says if A2 says cd, then D2 equals B2
or IF A2 says dvd, then E2 equals B2 or IF A2 says lp, then F2 equals B2.
How state the equation for it to do this?

 

[Norman Harker]

Hi Chamberlain!

You need three formulas:

D2:
=IF(A2="cd",B2,"")
E2:
=IF(A2="dvd",B2,"")
F2:
=IF(A2="lp",B2,"")

You may need to adapt for cases where A2 is a blank cell or contains
something other than cd, dvd or lp.

 

[hcj]

In cell d2 use =if(a2="cd",b2,"")
In cell e2 use =if(a2="dvd",b2,"")
In cell f2 use =if(a2="lp",b2,"")

Copy these down for each row of a and b data

-----Original Message-----
Column A will have values either cd, dvd, lp. Column B

has dollar values. I would like to have an equation that
says if A2 says cd, then D2 equals B2 or IF A2 says dvd,
then E2 equals B2 or IF A2 says lp, then F2 equals B2.
How state the equation for it to do this?