View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Largest of Two Values

Try this:

=MAX(B1,C1)

Returns whichever is the larger of the two.

Hope this helps.

Pete

"JerryS" wrote in message
...
I want a formula that returns the largest of two values located in
different
cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I
want
it to return either B1 or C1 with the criteria being if B1 is greater than
A1, then the answer is B1. If not, then the answer is C1. Any suggestions?
Thanks
--
JerryS