I am trying to write a formula that will do the following: I have a total quantity that is given in cell G30. I also have a total quantity that is in cell E29. I need a formula that says if G30 is greater than E29, use the E29.
Any help would be much appreciated.
Thanks!