How to use IF to pull in values from another column

Hello, I have the case below and need help with writing an IF statement:

Colume A:
N
Y
_ (blank)
N

Colume B:
Pre
Post
Post
Pre

I want an IF to do the following: If Col B="Pre", use blank and if Col A="Post" use value in Col A.
How would you write this?

Thank you so much for your help!!

Originally Posted by rcocalm

I want an IF to do the following: If Col B="Pre", use blank and if Col A="Post" use value in Col A.

I think what you meant to say was

I want an IF to do the following: If Col B="Pre", use blank and if Col B="Post" use value in Col A

Try
=IF(B2="Pre","",IF(B2="Post",A2,""))

Or if Pre and Post are the only 2 possible options for column B, then just
=IF(B2="Pre","","Post")

Yes, your rewrite of my question is correct: I want an IF to do the following: If Col B="Pre", use blank and if Col B="Post" use value in Col A.
I tried your 1st statement it doesn't pull in the values in Col A for the "Post" in Col B. Your second statment doesn't really work.

Does anyone else have an idea?

Thank you!!!

The statement is returning 0 when clearly i want to change it to "" (blank) when the value in Col A for Pre is blank. Why is that? So instead of getting "" as the return, I am getting 0s.
How do you fix this?

Can you post your book?

I would guess that your cells in column B don't = Pre or Post EXACTLY...
check them for extra spaces
"Pre " vs " Pre" vs "Pre"

here is my data set. There are blank values in col A for both Pre and Post. the IF is working for the Pre, but still returns 0 for the Post when the value is blank...
WIll you please check? Thanks alot!
Sorry i couldn't figure out where to upload the excel so this is an image...test.jpg
There is no extra space in Col B.

Try
=T(IF(B2="Pre","",A2))