Formula help - multiple conditions for IF function

Originally Posted by 6StringJazzer

Here is the formula you want to use in G2 and copy down, except the values in E are not exactly what you said. Here is the formula based on your description:

Formula:

=D2+IF(E2="A",250,IF(OR(E2="B",E2="C"),125,-D2-999))

This allows for a fourth case where there is an error in E, and it is neither "A" nor "B" nor "C". In such a case the result will be -999 to get your attention.

However, the data you have shows " A" with a space, not "A". It's better to fix that at the source, but the list you are using is in a different file so I can't change it. Here is a formula that assumes you don't fix it.

Formula:

=D2+IF(TRIM(E2)="A",250,IF(OR(TRIM(E2)="B",TRIM(E2)="C"),125,-D2-999))

Thank you Jeff! This worked! I also removed the space after the "A". Ooooops - rookie error! Thank you everyone for all of your help/suggestions