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

=A1+MAX(B1,C1)


--
Regards,

Peo Sjoblom



"MS Newsgroups" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

look in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"MS Newsgroups" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>