Sum of A1+A2+A3, but use A1 in sum only if it is greater than A2, if not use A2 - how to?

[GSJ1]

Hi there,

I need some help writing a formula for this:

The sum of A1+A2+A3, but use A1 in the sum only if it is greater than A2 (and if so then don't use A2), if not use A2 only...

Basically A1 cell represents the calculated brokerage on shares eg. $10, A2 represents the minimum brokerage eg. $15, and A3 represents the purchase value of shares eg. $100.

So the answer I want in this case is $15+$100=$115, as the $10 is less than the minimum amount it is not included in the sum.

Thanks for your help!

[Tony Valko]

Maybe this...

=MAX(A1,A2)+A3

[GSJ1]

Wow, awesome reply, it works, and so simple!
Thank you so much Tony, you have just saved me 5hrs!!!
Kudos.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.