Of course. The <> means not equal to, so it's looking down the column and counting every cell that's not equal to S, F, H or blank. If the figure is 0, it does nothing, but if it's anything else it returns "Error".
Of course. The <> means not equal to, so it's looking down the column and counting every cell that's not equal to S, F, H or blank. If the figure is 0, it does nothing, but if it's anything else it returns "Error".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks