M
MS Newsgroups
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
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