Good day! Please help with writing the formula in EXCEL under the following conditions: If the cell value is less than 3000, then it is necessary to indicate 3000 in it. If more, then leave the value indicated in the cell. Thanks in advance!

    2 answers 2

    Suppose your column is N.

    Create a new column next to it. Write

    =IF(N1>3000,N1,3000)

    or

     =ЕСЛИ(N1>3000,N1,3000)

    Further copy VALUES, transfer to the original column, delete the temporary one.

    PS I personally don’t know how to write a VB script, how to change the value in the same cell, at the same time writing both the data and the formula there.

    • Thank you, because I had to urgently, I hid the original column in a "cosmetic" way (in your example, "N"). Your answer helped me a lot. - Vintare
    • one
      @Vintare, If you are given an exhaustive answer, mark it as correct (click on the check mark next to the selected answer). - knes
      =МАКС(значение;3000)

    Naturally, not in the same cell. How to transfer, described in his answer knes

    • The value in the cell is calculated, but not entered, guessed? If yes, then instead of "value" a formula is substituted by which the cell value is calculated. - maestro
    • Constant, cell reference, formula - no difference. The author asked about the replacement of values: = MAX (A1; 3000) Then replace the formula with values. replace the original data received. - vikttur
    • There is a difference, because if there is a formula, then the actions proposed by the knes will not be needed. - maestro
    • Yes, if NOT CHANGING, but GETTING the value - vikttur