I have the following formula in BB20 =IF(BB19=0,"0",BB19/BB14)
I have dragged this formula along row 20 but where the data is yet to be filled in along row 14, BB14 I get the return of #DIV/0!
There is a formula in BB19 so when BB14 is blank there is a 0 in BB19
I dont want the message #DIV/0! until information is entered in row 14. Please advise
Bookmarks