Using two "NOT"s in one equasion

[singer.joseph]

This code is currently working correctly for me in the cell:
=IF(NOT(F3="Loose"),IF(C3="Yellow",", 1866",IF(C3="White",", 1867",IF(C3="Two Tone",", 1868",IF(C3="Rose",", 1869",IF(C3="White-and-yellow",",1870")))))," ")
However i would like to add something and i cant figure out where to add it maybe you could help me.

I would like to add another condition that if C3 is not any of the listed values (Yellow, White , ETC) and f3 does not = "Loose ", then the value 1871 will show.

Any help would be much appreciated.

Thanks and have a Great Day

Joseph

[Jonmo1]

Try this

Put your text strings (Yellow White etc) in a range of cells say G1:G5 (in the same order)

=IF(F3="Loose","",IF(ISNA(MATCH(C3,G1:G5,0)),", 1871",", "&MATCH(C3,G1:G5,0)+1865))

[singer.joseph]

Jonmo1,

thanks but it didnt work... any other ideas ?

[Jonmo1]

Jonmo1,

thanks but it didnt work... any other ideas ?

Works for me
2Notsalternate.xlsx


In what way did it not work for you?

[singer.joseph]

I am not sure i did exactly what you told me and the cell returned an empty value

Additionally in my code it is If(NOT(c3="loose")...... in the one that you posted its IF(c3="loose")... could that be the issue

[Jonmo1]

Additionally in my code it is If(NOT(c3="loose")...... in the one that you posted its IF(c3="loose")... could that be the issue

Actually, in your code it was if(NOT(F3="loose")
So your original posted formula checks F3 for "loose", but the rest of the if's are looking at C3...is that the problem maybe?


and the removing of the NOT is not the issue. I just reversed the logic of the IF.

Example
=IF(NOT(A1="x"),"YES","") <-Notice the "Yes" comes first as the result when the IF is TRUE
Is the same as
=IF(A1="x","","YES") <-Notice the "Yes" comes last as the result when the IF is FALSE