Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |