Forum Discussion
Using the IF function
Hello, I am new here and hoping that someone can help what is likely a basic question. Here is the formula I am using for what I will describe. It does not result in exactly what I want but it is a...
Ok Sergei, your suggestion has let me to what I needed. I changed the formula slightly to:
=IF(E4=H4|"U"|IF((E4>H4)*(E4<=I4)|"I"|"G"))
and have obtained the correct results. Thank you for the Lesson!
Lawrence, you are welcome. Just in case, if you manipulate with data in the same row within the table better to use structured references. Your formula will be like
=IF([@RESULT]=[@MDL],"U",IF(([@RESULT]>[@MDL])*([@RESULT]<=[@PQL]),"I","G"))
and attached