Our members are dedicated to PASSION and PURPOSE without drama!

need help to capture first number

Started by montis, April 05, 2014, 10:20:27 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

montis

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.

VLS

Hello Montis,

Over here we're more focused in systems programming.

You are more likely to find excel sheet programming assistance at http://betforum.cc/excel-forum/

Cheers!
Vic
Email/Paypal: betselectiongmail.com
-- Victor