Hi, struggling with what should be a pretty simple calculation and return.
I have a very large sheet of calculated values returned into a column. I want to set a maximum limit on the value returned so if the value calculated reaches the maximum value it sets the limit otherwise returns the result.
Pretty simple example here with the max capped value of 300 needing to be returned. How do i write a formula to return this max of 300 please?
Thanks in advance
I have a very large sheet of calculated values returned into a column. I want to set a maximum limit on the value returned so if the value calculated reaches the maximum value it sets the limit otherwise returns the result.
Pretty simple example here with the max capped value of 300 needing to be returned. How do i write a formula to return this max of 300 please?
Thanks in advance