HI, is there anyway anyone can help me?
Ive currently calculating 10 quarters of return on investment using quarterly sales divided by quartely promotion.
If a product has 0 sales and 0 promo, the value returned is DIV!0 not 0.
If a product does not have 10 quarters of data, both sales and promo will be blank and consequently the calculation returns a DIV!0 error.
How do i make it so that zero divided by zero will return a 0
and blank divided by blank returns a DIV!0 error.
Is the return error custonisable?
Thanks
Ive currently calculating 10 quarters of return on investment using quarterly sales divided by quartely promotion.
If a product has 0 sales and 0 promo, the value returned is DIV!0 not 0.
If a product does not have 10 quarters of data, both sales and promo will be blank and consequently the calculation returns a DIV!0 error.
How do i make it so that zero divided by zero will return a 0
and blank divided by blank returns a DIV!0 error.
Is the return error custonisable?
Thanks