How to indicate price with variable situations?
I need IF and AND formulas but I couldnt do.Is there anybody WHO can help to me
@Wyn Hopkins Hello,As you see on the picture,I want to see price placed on the right section when I choose model,engine,year and colour according to their price on the left section .Thank you
Thank you so much for comment.
Is it not possible using this formula ?
@OnurhanToy Hi, allow me to chip in.. the way I see it, @Sergei Baklan method is better in the sense that he's looking up the entire range so you can use that one formula.
The one you indicated, If(and; it is very specific and may require changes in order to work perfectly should you have new data going forward.
@crazyshoots Thank you very much for your help.
I'll try both