Welcome Guest.

2Answers

The maximum value of two temperature selection in the ELSX form in the same line

Asked by: Wood 18 views Software May 7, 2022

21 ° C / 12 ° C. In the same line of the same line, two temperatures seeks the same temperature in the same line. The largest temperature value <

2 Answers

  1. +2Votes  

    = max (-MID (substitute (a1 &” /”, “℃ /”, reply (“”, 98), {1,99}, 98)) &”℃”

    After losing the formula, press Ctrl+Shift+ENTER combination key

    Stephanie Clark- May 7, 2022 |

  2. +3Votes  

    If the two temperatures are in column A, the other column formula is

    = max (left (a1,2), MID (A1,5,2)) drop -down.

    Cheryl Simpson- May 7, 2022 |