Forum Discussion
Robert Imler
Dec 08, 2017Copper Contributor
Simple Question
I have different procedure codes for houses. If a house has one person, it will be w9000. If a house has two people, it will be w9029. I added a row in my spreadsheet that has number of people in each house. Do I use an if statement to automatically populate the w9000 or w9029 block.
- Detlef_LewinSilver Contributor
Robert,
without IF:
=CHOOSE(A1,"w9000";"w9029")