How to write a formula for SUM

[wberg82]

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!

 

[Joyner]

Hello, try: =IF(G30>E29,E29,E30)

 

[arthurbr]

Or =MIN(E29,G30)
(what happens when G30=E29?)

 

[alvisonhunter]

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!

Hello There,

This will solve your request: Please let us know how it goes!

=IF(G30>E29,E29,G30)