G
Guest
I'm trying to build a IIf function within a report, all I want it to do is if
the cell under column A is Yes, show nothing in the cell on the report and if
the cell under column A is No, then show N/A in the cell on the report. So I
typed:
=IIf([A]="Yes", " ", "N/A") and the error shows in all cells. What am I
doing wrong?
the cell under column A is Yes, show nothing in the cell on the report and if
the cell under column A is No, then show N/A in the cell on the report. So I
typed:
=IIf([A]="Yes", " ", "N/A") and the error shows in all cells. What am I
doing wrong?