I have two formulas/functions that I need to run on each cell - the first one is the rank which is working fine...
=RANK(B13,$B$2:$B$30,0)
The 2nd function is that I need the cell to be blank if there is nothing in B13. There is another formula that is adding all the rankings up. Currently, putting the ranking formula results in a #N/A in the cell - messing up the entire sheet.
What am I supposed to put before or after the rank formula to keep the cell blank until something is enterred?
THANKS!
=RANK(B13,$B$2:$B$30,0)
The 2nd function is that I need the cell to be blank if there is nothing in B13. There is another formula that is adding all the rankings up. Currently, putting the ranking formula results in a #N/A in the cell - messing up the entire sheet.
What am I supposed to put before or after the rank formula to keep the cell blank until something is enterred?
THANKS!