Forum Discussion
Excel IF/AND/OR formula support
I have 2 formulas that I need help with - For this first formula, I cannot get the field to give me data for all names and levels it ONLY gives me data for all levels of Bronze but not the others. ...
First formula. Logic is not exactly clear. Your formula:
=IF(AND($C$13="Bronze",$D$16="Level 1"), Bronze!K15,
IF( $D$16="Level 2", Bronze!V15,
IF( $D$16="Level 3",Bronze!AG15,
IF( $D$16="Level 4",Bronze!AR15,
OR(
IF( AND( C13="Silver", D16="Level 1"), Silver!K15,
IF( D16="Level 2",Silver!V15,
IF( D16="Level 3",Silver!AG15,
IF( D16="Level 4",Silver!AR15,
IF( AND(C13=”Gold”,D16-"Level 1"),Gold!K15,
IF( D16="Level 2",Gold!V15,
IF( D16="Level 3",Gold!AG15,
IF( D16="Level 4",Gold!AR15,
IF( AND(C13=”Platinum”,D16-"Level 1"),Platinum!K15,
IF( D16="Level 2",Platinum!V15,
IF( D16="Level 3",Platinum!AG15,
IF( D16="Level 4",Platinum!AR15,))))))))))))
)
))))Perhaps you mean
=IF( $C$13="Bronze",
IF( $D$16="Level 1", Bronze!K15,
IF( $D$16="Level 2", Bronze!V15,
IF( $D$16="Level 3",Bronze!AG15,
IF( $D$16="Level 4",Bronze!AR15, "nothing")))),
IF( C13="Silver",
IF( D16="Level 1", Silver!K15,
IF( D16="Level 2",Silver!V15,
IF( D16="Level 3",Silver!AG15,
IF( D16="Level 4",Silver!AR15, "nothing")))),
IF( C13="Gold",
IF( D16="Level 1",Gold!K15,
IF( D16="Level 2",Gold!V15,
IF( D16="Level 3",Gold!AG15,
IF( D16="Level 4",Gold!AR15, "nothing")))),
IF( C13="Platinum",
IF( D16-"Level 1", Platinum!K15,
IF( D16="Level 2",Platinum!V15,
IF( D16="Level 3",Platinum!AG15,
IF( D16="Level 4",Platinum!AR15, "nothing"))))
))))That is here:
Thank you but now it is changing every field and not individual fields - so if I change the level in D16 then all Fields Under cost are exactly the same and change together. I am trying to get it to where each field under level of effort will change the specific cost under the Cost field corresponding to the level of effort in the same row.
I changed formula only in this very cell
and didn't change the rest. That's only reverse engineering of your initial formula, have no idea what is the business logic behind.