Forum Discussion

norman_C's avatar
norman_C
Copper Contributor
May 27, 2025

IF formula function

I want to create a formula for three columns A3, B3 and C3 wherein if A3<B3 then the result is shown in D3 as the median of B3 and C3. If A3 is > C3 then the result is shown PTI

Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    May 27, 2025

    in D3 enter:

    =IF(A3<B3, MEDIAN(B3,C3), IF(A3>C3, "PTI", "other results"))

    so what happens if A3 is >=B3 but <=C3? In the above I output "other results".

    I also wasn't sure if PTI was something special or just the text "PTI"

    And if you are just doing the MEDIAN of 2 numbers that is the same as AVERAGE or (B3+C3)/2

Resources