need help to capture first number

[emporata]

Hello,
I need help
I have excel formula which let for different numbers appear in the same cell,
=IF(OR(F7={10,10.5,11,11.512,12.5,13,13.5,14,14.5,15}),5,IF(OR(F7={15.5,16,16.5,17,17.5,18,18.5,19,19.5,20}),11,IF(OR(F7>=20.5),15,"")))

for example we have AS1 cell in which appear first number 15, then it change to 5, then it change to 15, then it change to 11 etc. What i need is to capture and lock just the first shown number (in this ex. it has to be 15) and put it to another cell (for ex. cell AT1)
Maybe there is any formula ?
Thanks.
M.

[RudiS]

Unfortunately, when you use a formula, it will be dynamic. The moment the value changes in F7, it will update in AS1, and if AT1 is also a formula, it will change every time the value in AS1 changes.
On the other hand, if a macro does this: Changes the AT1 value to a hard-coded number whenever AS1 changes, it will also trigger every time...which defeats the purpose.
Is there a way that we can determine what the first shown number is. Like lock it to never change if a date for that record is after today's date???

[Richard Buttrey]

Hi,

It's not clear to me what you want.

Would you upload your workbook and manually add the results you expect with some explanatory notes.

Just as an observation, and I know you're not looking for a shorter formula, but

Please Login or Register  to view this content.

would seem simpler than your current formula

[emporata]

Thanks Rudis for opinion and Richard for better formula. I agree, that there isn't easy way to solve this problem. Just have to choose another way.

E.