add max(0,....) to several cells

Hello,

I have several CELLS with lengthy formulas and numeric values. When I edit the inputs, some of the numbers in my CELLS become negative and I want to prevent them from doing so. I want the CELLS to reflect the maximum of 0 and the formula output. I know that I can fix it by adding =MAX(0,FORMULA) to each cell, but that would be very time consuming. Is there a way to add the max function to several cells simultaneously?

Thanks in advance

You can do it using Find & Replace (CTRL-H) a few times, but you need to look for common endings to your FORMULA to get the close bracket to be added in. Essentially, you select all the cells that you want to change, and on the first pass of CTRL-H you can change = to something like $$=, so that it is no longer a formula in those cells. Then you can change = to =MAX(0, and then change the formula ending to include the close bracket, and finally change $$= back to =

It does depend on what your formula looks like.

Hope this helps.

Pete

Thanks!!!

@Pete this is brilliant and solved my problem.

Well, that's good to hear. As I said, this method depends on finding something unique at the end of the formula, so it might be a close-bracket or two, or a quote and close bracket.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

@Pete done and done. Thanks again.