Is there a way of using the IF formula to print what is in a cell on a second worksheet if the answer to query on the first worksheet is correct?
ie - in cell B3 asking about A3 and if query is correct printing what is in B3 on second worksheet.
Thanks
We'd need help understanding how the second sheet will know if the query is correct or not, but the comparison is simple enough:
=IF(Sheet1!B3="dog",Sheet1!B3,"")
I'm just showing an example of how you can include the verification of whether the answer is correct or not with "dog". It could also be
=IF(Sheet1!B3=Sheet1!A3,Sheet1!B3,"")
Hopefully you get the idea.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The example I'm trying to use is: In cell B3 (worksheet 2), question , if cell A3 (worksheet 2) is( 1 ) then copy cell B3 from (worksheet 1) in cell B3 (worksheet 2).
Trying to get the data from Worksheet 1 to Worksheet 2 if the query is correct.
Hm, if I follow your logic correctly:
=IF(Sheet2!A3=1,Sheet1!B3,"")
Thanks, that worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks