Excel Formula - If And on Blank Cell
Posted on 2016-11-11
I have an excel database I created to use with Tableau to calculate my Net Promoter Score (NPS) for my CSI results. The Formula is:
The result I need is If the cell is less than 7 input a 1, if it is a blank, input a 0. It is not working, it only enters a 0 for everything. What am I doing wrong?