Forum Discussion
Lawrence Drennan
Sep 14, 2018Copper Contributor
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...
SergeiBaklan
Sep 14, 2018Diamond Contributor
Hi Lawrence,
Perhaps
=IF(E4=H4,"U",IF((E4>H4)*(E4<E3),"I","G"))
if I understood your logic correctly. And attached.
Lawrence Drennan
Sep 14, 2018Copper Contributor
Thank you Sergei! I will give it a try and let you know.