conditional formula using IF then

[Dexter11]

I have a variance data column which I need to analyze as follows;

if the number is over or under $20,000, then insert a "B" in a specified column. I'm new with excel and I've been looking at the IF statements but don't know how to go about in setting up the formula. Please help. Thanks.

 

[Misca]

Try putting

=IF(A1=20000,"","B")

in the column where you want the "B" to appear. Just change the A1 to the actual cell reference.

 

[Dexter11]

Misca, thank you for your input. However, I'm not sure if this will work because my 20,000 is if it's either over 20,000 or under 20,000. Your suggestion only shows if it = 20,000.

Also, how would I set up an if statement for the following which is similar but with an added criteria;

I want to put a B for an amount which is over or under 10,000 (this is for my variance amount) AND 10% under a variance percent column.

Thanks!