Forum Discussion
Need a Formula to Review Two Criteria and Return Multiple Values
I need to write a "complicated" formula and don't have the first idea of what function to use so searching is not helping me. I'm down a rabbit hole and in need of help! Gist: I have three col...
OliverScheurich
Thank you for taking the time to create this complicated formula. I would never have figured that out! I apologize for my delayed response. I had set the projcect aside when I got stuck and have finally resumed today.
I used this formula, but I get nothing but blanks. I don't get any values in column AF, and no error messages about the formula.
Cannot seem to figure out what I am doing wrong. Mind helping again?
IF(AND(L2="Teamraiser Registration Gift",AE2="TRUE",AI2="TRUE"),"Additional",IF(AND(L2="Teamraiser Registration Gift",AE2="FALSE",AI2="TRUE"),"Reg Fee",IF(AND(OR(L2="Teamraiser Gift",L2="Sustaining Gift"),OR(AE2="TRUE",AE2="FALSE"),AI2="TRUE"),"Later Gift",IF(AND(OR(L2="Teamraiser Gift",L2="Sustaining Gift"),OR(AE2="TRUE",AE2="FALSE"),AI2="FALSE"),"Other Donor",""))))
Thank you for taking the time to create this complicated formula. I would never have figured that out! I apologize for my delayed response. I had set the projcect aside when I got stuck and have finally resumed today.
I used this formula, but I get nothing but blanks. I don't get any values in column AF, and no error messages about the formula.
Cannot seem to figure out what I am doing wrong. Mind helping again?
IF(AND(L2="Teamraiser Registration Gift",AE2="TRUE",AI2="TRUE"),"Additional",IF(AND(L2="Teamraiser Registration Gift",AE2="FALSE",AI2="TRUE"),"Reg Fee",IF(AND(OR(L2="Teamraiser Gift",L2="Sustaining Gift"),OR(AE2="TRUE",AE2="FALSE"),AI2="TRUE"),"Later Gift",IF(AND(OR(L2="Teamraiser Gift",L2="Sustaining Gift"),OR(AE2="TRUE",AE2="FALSE"),AI2="FALSE"),"Other Donor",""))))
Hi OliverScheurich! The formula you gave Holly_Michaelson worked out for me, in my scenario. I do have a slight difference I am trying to achieve and could not figure out the correct way to manipulate it. I in turn would like to return a value based on the what the text is in the referenced field, so if it says "COOL, WARM, or HOT", I want it to return "Chill" for cool, "Nice" for Warm, or "Bad" for Hot. Would you know how I can set this up in a formula in excel?
Ex:
| Cool | = "Chill" |
| Warm | = "Nice" |
| Hot | |
| Warm | |
| Cool | |
| Cool | |
| Hot | |
| Warm | |
| Hot |
Hi, andii2617 you can try this nested IF formula.
=IF(A1="Cool","Chill",IF(A1="Warm","Nice",IF(A1="Hot","Bad","")))- OliverScheurich, thank you!!! That worked!
