nortellini
New Member
- Joined
- May 13, 2004
- Messages
- 28
Good morning/evening everyone!
I am trying to create an IF query to return a certain value if a condition is satisifed. As follows:
If Column A equals 'Yes', I would like to populate Column D with the value of Column B.
However, if Column A equals 'No', I would like to populate Column D with the value of Column C.
I am clearly a moron with no grasp for simple formula - can one of you more enlightened and helpdeul people advise?
Many many thanks in advance
Regards
Chris
I am trying to create an IF query to return a certain value if a condition is satisifed. As follows:
If Column A equals 'Yes', I would like to populate Column D with the value of Column B.
However, if Column A equals 'No', I would like to populate Column D with the value of Column C.
I am clearly a moron with no grasp for simple formula - can one of you more enlightened and helpdeul people advise?
Many many thanks in advance
Regards
Chris