If and Or Functions in Same Cell

  • Thread starter Candentco Creative Collection
  • Start date
C

Candentco Creative Collection

Before I pull out the last of my hair, can someone please correct the
following formula:

=IF(or(ABS(F35/D35)>3%)),(ABS(F35/e35)>3%)),"Yes","-")

I am sure it is something stupid that I am doing or not.

Thanks a bunch!
 
J

JE McGimpsey

One way:

=IF(OR(ABS(F35/D35)>3%, ABS(F35/E35)>3%), "Yes", "-")

Candentco Creative Collection
 
C

Candentco Creative Collection

The world should be grateful for you smart pros that save our lesser smart _
_ _ _s!
 

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