IF and AND Statements

[fsdeniro]

Hello,

Struggling to figure out how to use IF and AND function. I would appreciate any help!

Cell A1= 1
Cell A2= 1
Cell A3=5
Cell A4=2.5
Cell A5= 3
Cell A6= 10

I want to create formula that looks at Cell A1 and if the value if 1 then return value of Cell A3/Cell A4 (2). If value in Cell A1 is not 1 then it looks at Cell A2. If Cell A2 is 1 then return value in Cell A5 (3), if not then value in cell A6 (10).

Looks simple but I can't get to it.

Thanks
Frank

 

[Desu Nota from Columbus]

cell a1= 1
cell a2= 1
cell a3=5
cell a4=2.5
cell a5= 3
cell a6= 10
i want to create formula that looks at cell a1 and if the value if 1 then return value of cell a3/cell a4 (2). If value in cell a1 is not 1 then it looks at cell a2. If cell a2 is 1 then return value in cell a5 (3), if not then value in cell a6 (10).

=if(a1=1,a3/a4,if(a2=1,a5,a6))

 

[fsdeniro]

Thank you for your help.

Frank