A formula to use the greater value in a field

K

Kelly

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.
 
N

Niek Otten

=MAX(E124,G125)*C127

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
K

Kelly

I'm sure I'm not asking the question right. So it's my bad, but....I’m trying
to have the formula in cell G127, which is my CAC, to use the greater value
in Cell E125, which is my Budgeted Units, or Cell G125, which is my JTD
Units.

The formula I have in the cell now is E125*C127. C127 is my Unit Actual
 
Top