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.

excel formulas
 

hi MatileM,

try it

=if(and(F6=false;G6=false;H6=false);"exclude";if(a nd(F6=True;G6=True;H6=True);"Allow to Bid";if(or(G6=True;H6=True);"Get More Information""Exclude")))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MatileM" escreveu:

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.

excel formulas
 

sorry for the first post, I forgot to change the ; by the ,

here you are

=if(and(F6=false,G6=false,H6=false),"exclude",if(a nd(F6=True,G6=True,H6=True),"Allow to Bid",if(or(G6=True,H6=True),"Get More Information","Exclude")))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MatileM" escreveu:

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.