×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# 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,

Just traded in my OLD subtlety...
for a NUance!

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

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!