Jo asked in Computers & InternetSoftware · 4 weeks ago

looking to create a formula in excel: for example if cell > 104 then i want cell to - 104 / 2?

2 Answers

Relevance
  • DEBS
    Lv 7
    4 weeks ago

    Assume 104 is in cell B3.  In a different cell (like C3):  if(B3>104,104/2,B3)

    If 104 is actually a formula and you want to have the result directly in the same cell instead of a different above, then If({your existing formula}>104, {your existing formula}/2,{your existing formula})

    • Login to reply the answers
  • 4 weeks ago

    Your explanation is insufficient

    but

    the general technique is to put a formula in one cell in the range

    and then copy that cell

    and paste it into the remainder of the range.

    Then you'll have that formula repeated for each cell in the range.

    For example:

    imagine you have data in column A

    In column B you want to perform a calculation on each cell in column A such that

    for each cell Ax, cell Bx = (Ax - 104)/2

    To do that

    in B1 you put the formula

    = (A1 - 104) / 2

    Then you copy cell B1

    and paste to cells B2..B100 (or however far you want)

    • Login to reply the answers
Still have questions? Get your answers by asking now.