Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
n.almeida
 
Posts: n/a
Default

I am not sure if I got it.
I understand there is a reference value say "100" that occurred on 1st March
and you want to know if the certain results on A1 get over "100" the date is
registered otherwise the get the date of the "100" value.
On B2 put the date of the A2 value. And on the A4 =IF(A1A2,TODAY(),B2)

If you want to save the maximum of several tries that change the result
automatically I don't think it will be possible. A formula will always
change, as far as I know and you cannot freeze it if some conditions are met.
In any case, the value on A2 would have to take the new maximum so that the
sheet could continue to be used, isn't it?

Now, you
....either record the maximum records on a list somewhere, and link A2 and B2
to that list;
....or change manually the 100 to the new max say 120 and the date with the
copy values.
....or I have no idea of what I am talking about and will leave it...
b&a,n__o
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Condition IF Jeff Excel Discussion (Misc queries) 3 February 15th 05 10:19 PM
Adding different validations based on condition Solis Excel Worksheet Functions 1 December 3rd 04 04:37 PM
Cannot sum values based on condition Ned Flanders Excel Worksheet Functions 1 December 3rd 04 04:36 AM
Add condition to formula Pat Excel Worksheet Functions 0 November 16th 04 12:23 PM
External reference as a condition Ingeniero1 Excel Worksheet Functions 2 November 12th 04 07:10 PM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"