Forum Discussion
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
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