×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

excel; replace max value with calculated value

excel; replace max value with calculated value

excel; replace max value with calculated value

(OP)
This should be simple, but I am puzzled.

I have a spreadsheet that keeps track of supply costs per month. When a new max is reached, I have a call that indicates, "new max". I won't to automatically replace the number in the corresponding cell to show the new Max Value;

I tried the formula, =IF(K68="New Max", G68=B68). It returns "False each time. We had this working at one time on an earlier spreadsheet which I have been unable to find.

Any ideas will be appreciated.

RE: excel; replace max value with calculated value

Seems that it is not a VBA solution, there is forum68: Microsoft: Office dedicated to other than acces MS office applications.

If you plan to return either G68 or B68 depending on K68 contents, then =IF(K68="New Max",G68,B68).

combo

RE: excel; replace max value with calculated value

Formulas cannot change the value of other cells.

VBA can.

A new (possibly only preview for "insiders") feature called lambda functions might be able to.

RE: excel; replace max value with calculated value

Bill,

1) Why would you have such an important aggregation way down in row 68!? Just like Bob Uker, who thought he was in the "front row," it seems to me that important aggregations ought to be right at the Top, easy to find in Row 1!

2) You "have a call that indicates, 'new max'". What does that mean?

It seems that you view the "spreadsheet that keeps track of supply costs per month" and make a judgement that some aggregation has exceeded the current value and then do something like typing the new max value in a designated cell. Maybe you want a button that transfers that value to the designated cell, yes?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close