View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default A formula to use the greater value in a field

Typo patrol.....!!

Should be C127 and entered in G127


Gord

On Thu, 16 Nov 2006 13:33:08 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Kelly

=MAX(E125,G125)*G127


Gord Dibben MS Excel MVP


On Thu, 16 Nov 2006 12:52:02 -0800, Kelly
wrote:

How can I, or can you, do the following: This is my formula: E125*C127.
Budgeted Units = E125, JTD Units = G125, CAC = G127 What I need to be able to
do is have the formula use the greater value in field E125 or G125.