Forum Discussion
IF statement on MS Excel
Hello, I need some help with the IF formula on the attached sheet; I'm not clear if the IF OR statement or IF XOR would do this. Column C has 3 possible entries, column D has 5 possible entries (...
Alfredokosun , it could be
=IFNA(IF((D4="Lagos")+(D4="Portharcourt")+(D4="Abuja"),LOOKUP(C4,{3,"5&4",6},{18000,13500,12500}),IF((D4="Kano")+(D4="Other States"),LOOKUP(C4,{3,"5&4",6},{12000,9500,8500}),"")),"wrong data")
but better all constants to put into cell ranges
Thank you, SergeiBaklan This is helpful!
Alfredokosun , glad to help