• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF, AND Statements from another Excel Sheet

R

rod411

New Member
I have the following
=CLASS!A2 but when I add an IF statement it gives error. I am not doing it right.

If A2 in the CLASS worksheet is "Yes" THEN I need an X to appear on F2 of the PROFILE worksheet

If A2 in the CLASS worksheet is "No" THEN I need an X to appear on G2 of the PROFILE worksheet
 
rod411 said:
I have the following
=CLASS!A2 but when I add an IF statement it gives error. I am not doing it right.

If A2 in the CLASS worksheet is "Yes" THEN I need an X to appear on F2 of the PROFILE worksheet

If A2 in the CLASS worksheet is "No" THEN I need an X to appear on G2 of the PROFILE worksheet
Click to expand...
Hi,

Put this in F2 on the PROFILE sheet

=IF(Class!A2="Yes","X","")

and this in G2

=IF(Class!A2="No","X","")
 
rod411 said:
I have the following
=CLASS!A2 but when I add an IF statement it gives error. I am not doing it right.

If A2 in the CLASS worksheet is "Yes" THEN I need an X to appear on F2 of the PROFILE worksheet

If A2 in the CLASS worksheet is "No" THEN I need an X to appear on G2 of the PROFILE worksheet
Click to expand...


Hi,

Give me a sample file
 
You must log in or register to reply here.
Back
Top