IF formula error: False

Solved/Closed
Eryn - Oct 9, 2015 at 03:37 PM
Hello,

I'm trying to get one of three answers to show up in my excel document. Currently I have:
==IF(((J43/I43)*100)>=81,"APPROVED")&IF(OR((J43/I43)*100)<81,((J43/I43)*100)>=6,"CONDITIONAL")&IF(OR((J43/I43)*100)<6,"NOT APPROVED")

Either Approved - Conditional - False is supposed to show up (only one). Instead I'm getting: FalseConditionalFalse.

What am I doing wrong?