If and Or Functions in Same Cell

G

Guest

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
 

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

Similar Threads

If or 3
If formula 4
Help with if then function 2
Problem with if function in excel 4
HELP!! Change formulas programmatically -- all I get is text! 7
If , Mid or right functions or a combination thereoff. 3
Help with IF or VLOOKUP (I'm not sure which formula to use) 1
iserror and ifs nested formulas 3

Top