Addition if one value is greater

  • Thread starter Thread starter MS Newsgroups
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Finding value using greater than, Vlookup, and nested If 2
2nd condition in a conditional formatting not working 9
Excel Conditioning Formatting 3
Greater, equal to or less than question 2
Conditional Formatting question... 1
Greater than, less than, AS WELL AS value=0 5
AND IF STATEMENT 1

Back
Top