IF / THEN question

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

Hello there,

I believe the below formulas should do it:

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

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.

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

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.

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

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.

Remove the quotation marks around the C2*0.5

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

Liz