I have a simple formula as follows:
=ROUNDUP(D11-D14,0)
Some of the values this returns are negative how can I change the formula to return a 0 if this is the case. I need to discount the negative values as I need to total them up at the end and the negatives are corrupting my result.
Hope someone can help
Thanks
Sara
=ROUNDUP(D11-D14,0)
Some of the values this returns are negative how can I change the formula to return a 0 if this is the case. I need to discount the negative values as I need to total them up at the end and the negatives are corrupting my result.
Hope someone can help
Thanks
Sara