Addition if one value is greater

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MS Newsgroups - 05 Sep 2007 16:13 GMT

I have a dilema.
In A1 I have (for instance) $100.00
There are other cells that I need to add to A1. I know what I need to do is
use an IF statement and I can do that.
I can evaluate IF one cell is greater than the other...but I need the
formula to decide WHICH value is the greater of the two and THEN add it to
A1.

Any suggestions out there in 'Smarter than ME land?"

Dave French

Reply to this Message

Peo Sjoblom - 05 Sep 2007 16:17 GMT

=A1+MAX(B1,C1)

Signature

Regards,

Peo Sjoblom

>I have a dilema.
> In A1 I have (for instance) $100.00
[quoted text clipped - 7 lines]
>
> Dave French

Reply to this Message

Don Guillett - 05 Sep 2007 16:19 GMT

look in the help index for MAX

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I have a dilema.
> In A1 I have (for instance) $100.00
[quoted text clipped - 7 lines]
>
> Dave French

Reply to this Message