A formula to use the greater value in a field

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

Guest

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.
 
=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.
 
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
 
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 2002: Auto Filter Sub Total formula 4
Run-Time error '1004': No cells were found 13
Don't show a zero value: =IF(F8=0,"",E8/F8) 2
Trying to change a formula 4
I get a #VALUE! msg. 4
Creating an intentional 'Circular Reference' of sorts in '03 &'07 3
Updating Code when a row is inserted 8
greater of two values 1

Back
Top