IF / THEN question

[Creutzburg]

Hello,

I'm fairly new to the world of excel. I've been browsing the forum for quite a while, but I'm finding it hard to find a solution to my specific question.
I'd like to do the following:
- If D2 is Name1, then F2 = 50% of C2.
- If D2 is Name2, then G2 = 50% of C2.

Thanks so much already in advance!

Liz

[jeffreybrown]

Try

=IF(OR(D2={"Name1","Name2"}),C2*0.5,"")

[rvasquez]

Hello there,

I believe the below formulas should do it:

Please Login or Register  to view this content.

where you would replace the last "" with either text between the apostrophes or a calculation you would like to appear in F2 if D2 is not "Name1". Right now it states to show nothing.

Please Login or Register  to view this content.

where you would replace the last "" with either text between the apostrophes or a calculation you would like to appear in F2 if D2 is not "Name2". Right now it states to show nothing.

[Cutter]

That's not it Jeff. It's 2 separate formulas in F2 and G2.

[shekhar1660]

Hi Liz,

Are you looking for solution in VBA or Excel?
Both the statements are almost same:
- If D2 is Name1, then F2 = 50% of C2.
- If D2 is Name2, then G2 = 50% of C2.

[jeffreybrown]

@Cutter,

And I knew that I just blanked out

F2=IF(D2="Name1",C2*0.5,"")

G2=IF(D2="Name2",C2*0.5,"")

[Creutzburg]

Thank you already for the quick replies. I used the codes you gave me, but I'm getting an error.
I've attached the document for you to see.

[jeffreybrown]

Take the quotes off of the formula. Should look like

=IF(D2="Lisanne",C2*0.5,"")

[rvasquez]

Remove the quotation marks around the C2*0.5

[Creutzburg]

Got it! Thanks very much guys!
I appreciate it.

Liz