Thread: excel formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MatileM MatileM is offline
external usenet poster
 
Posts: 1
Default 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.