IF function

P

Paula

I need to write a if statement and having difficulties. I am trying to say if
one cell is plus or minus 10% and also if another cell is plus or minus
$10,000, if both are true then check or review. I know this is probably easy
for someone out there. Please share your knowledge.
Thanks.
 
L

Luke M

I'm assuming you meant plus or minus within your specified boundaries?
A2 = first cell
A3 = second cell

=IF(AND(A2<=0.1,A2>=-0.1,A3<=10000,A3>=-10000),TrueCondition,FalseCondition)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top