Hey everybody,
I'm trying to work out a way to keep some cells blank when there's no data in them. I'm using the =Max(B4:F4) function to get the largest number in the row, but I'd like the cell that displays the max number (G4) to be blank when there's no data inputted in the row. I've tried everything I can think of, but to no avail. Does anyone have any suggestions?