Movements possible

[Np72]

Hi,

Is there anyway that an IF statement will do increments. i.e. If you have a holding of security holding at 5 can you do the following

If holding moves up or down by 1 then is flagged.

 

[Joe4]

I am afraid your question is not very clear.

Can you post of an example of what you are looking for?

 

[Np72]

You have a holding

Stock A Holding
MREXCEL 8.1

What I'm trying to get is if the holding moves by 1.00 i.e. 7.1 - 9.1 then flag. However if it moves under 1.00 then not flag

 

[Joe4]

OK, but what does your worksheet look like?
What are you comparing this to?
How does this data move, within the worksheet?
Are there multiple rows of data for this holding, each with different prices?

Don't skimp on the details, the more information you give us, the better the answer we can provide!

 

[Np72]

<TABLE style="WIDTH: 439pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=583 border=0 x:str><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" span=2 width=82><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4717" width=129><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 33.75pt" height=45><TD class=xl24 id=td_post_2646808 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 62pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 33.75pt; BACKGROUND-COLOR: transparent" align=left width=82 height=45 x:str="Todays ">Todays </TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 62pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=82></TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 97pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=129></TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 36pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=48></TD><TD class=xl24 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 60pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=80></TD><TD class=xl30 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 59pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=left width=78>Last Disclosed</TD><TD class=xl25 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 63pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=left width=84>Disclosed Comp movement</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl26 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:num="-0.85767576290259118">-0.857676%</TD><TD class=xl27 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">94,674,472.00</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">Mr Excel</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">EUR0.08</TD><TD class=xl28 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">FR0000054470</TD><TD class=xl31 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right x:num="-0.81299999999999994">-0.8130

<!-- / message --><!-- sig --></TD><TD class=xl29 id=td_post_2646808 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" x:num="4.4675762902591232E-2">0.044675763</TD></TR></TBODY></TABLE>

Its comparing todays against last disclosed comp.The comp movement needs to flag if todays movement rises to -0.9130 or falls to -0.7130. So anything/movement +/-1.

 

[Joe4]

It looks like you are looking for movement greater than or equal to .1, not 1.

It appears that your last column is showing the difference. Let's say that is in cell D2. Then you formula might look something like this:

=IF(ABS(D2)>=.1,"FLAGGED","")