How do i use the "if" to produce 3 answers

I am trying to get the if function to produce a yes, no, n/a value. I use, if(is the item fuzed =Yes;Fuzed;Unfuzed) how do i get the n/a to be included?
Screenshot 2024-04-25 155146

Welcome to the Make community!

You can wrap the if function with an ifempty function.

2 Likes

ifempty(if(is the item fuzed =Yes;Fuzed;Unfuzed);n/a)

Like this adding ifempty function around if functuon will do the trick

Princy Jain
Make consultant,
For consulting support: Follow up Automated

2 Likes