In Google Sheets I have a column (column M) which has values of either "-" or a number. I'm trying to figure out if there is a way to make a formula that would divide column M by column N only if the value in column M isn't a "-"
I tried several variations on the formula below but could not make it work.
=IF(M2="-","-",(=M2/N2))