excel formulas
I am trying to create an excel spreadsheet with a multiple function equation
at the end, but I cannot seem to get it to work properly.
Here are the rules for the equation:
Rule #1: true if the customer's net worth is greater than $500,000, false
otherwise
Rule #2: true if bidder's CCAR rating equals 1 and bidder's stress risk
class equals 1, false otherwise
Rule #3: true if the bidder's PAYDEX score is over 90, false otherwise
This is my formula:
IF(AND(F6=FALSE,G6=FALSE,H6=FALSE),"Exclude",IF(OR (G6=TRUE,H7=TRUE),"Get
More Information"),IF(AND(F6=TRUE,G6=TRUE,H6=TRUE,"Allo w to Bid","Exclude")))
I have all of the other cells working properly, I just cannot figure out
this equation.
|