I need help with what should be easy formula but I can't get it right. I have the following figures:
<tbody>
</tbody>
The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the minimum?
thanks!
2 | 2 | 0 | 0 | 10 | 0 | 0 |
<tbody>
</tbody>
The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the minimum?
thanks!
Last edited by a moderator: