if a = x & b = y then use y help please

[Bill Williams]

Hi Guys
I have an "if" query

If A2 is > 0 then use A2 else if A3 is > than use A3 else use A4

Obviously I am have no idea what I'm doing & need some help

Much Appreciated Bill

[Sindhus]

Hi, Your requirement looks like a nested if formula. it will be like

Please Login or Register  to view this content.

And please make sure your title meets the forum rule.

[abbinv]

I am not sure if this helps:

=IF(AND(a=x,b=y),'y')