Help with if statement

[pmerlau]

Trying to do a double if statement. In one column I have a number but I want to get a result if the number is less than -99999 or over 99999 and give me a result of a one. Right now I have have the column with (11mm) as a conditional format, but I want to put a value in another column that if it meets this criteria then put a "1" in there. any help would be appreciated[TABLE="width: 407"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 98, bgcolor: transparent"] Total Sum of Actual Ending Bal [/TD]
[TD="class: xl65, width: 100, bgcolor: transparent"] Total Sum of Prior Year Ending Bal [/TD]
[TD="class: xl65, width: 105, bgcolor: transparent"] Total Sum of Variance in $ [/TD]
[TD="class: xl66, width: 110, bgcolor: transparent"]Total Sum of Variance in %[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3130[/TD]
[TD="bgcolor: transparent"]PAYABLE ACCRUALS - GENERAL[/TD]
[TD="class: xl63, bgcolor: transparent"] (1,000,000.00)[/TD]
[TD="class: xl63, bgcolor: transparent"] 10,000,000.00 [/TD]
[TD="class: xl63"] (11,000,000.00)[/TD]
[TD="class: xl64"]-110%[/TD]
[/TR]
</tbody>[/TABLE]

 

[NeonRedSharpie]

=IF(OR(A1<-99999, A1>99999), 1, "Value if not met")

 

[Hercules1946]

You may need to give more explanation or examples, but based on what your saying:

=IF(OR(A1 < -99999, A1 > 99999), 1, "")