Need excel formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I find the larger amount of 2 cols, then get difference between that
amount and 3rd col?
Thanks
 
=C2-MAX(A2,B2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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

match and extract 4
Averaging many non-contiguous cells if they are blank 1
matching only once 3
Complicated SUM IF formula 2
sumif error 4
Vlookup 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
sumif using "AND" and "Date" 2

Back
Top