Logic Question

Copper Contributor

Within the same Cell I am trying to show if "y" then -1 (and if not "y" then leave space blank) but can not get any response but "NAME"

when I enter it.  Suggestions please

Thanks

1 Reply

pls see attached file.

hope you can make something out of it.

thanks..