RE: Changing 0 to no and 1 to yes from a grid to a form

Vinton Douglas

Hello,

I have a some columns on a grid with possible scores of 0 or 1. How can 0 be reflected on a form created from the grid as "no" and 1 be reflected as "yes"?

Heath Hilton

Vinton Douglas,

This one is a pretty easy formula but I added a bit extra just in case you come across a 'blank' cell or one the doesn't show a 0 or 1.

=IF([Value (0 or 1)]@row = "", "", IF([Value (0 or 1)]@row = 0, "No", IF([Value (0 or 1)]@row = 1, "Yes", "Invalid")))

Let me know if you have any trouble with this.

Heath Hilton

Vinton Douglas,

This one is a pretty easy formula but I added a bit extra just in case you come across a 'blank' cell or one the doesn't show a 0 or 1.

=IF([Value (0 or 1)]@row = "", "", IF([Value (0 or 1)]@row = 0, "No", IF([Value (0 or 1)]@row = 1, "Yes", "Invalid")))

Let me know if you have any trouble with this.

Vinton Douglas

Superb. Thanks much.