Set cell value

[Solved/Closed]
Report
-
Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
-
Hello,
how to create formula for:
if AI=1, B1=2 than show C1= 25.......
if A1=1 B1=3 than show C1=28........
if A1=5 B1=5 than show C!=32....

1 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
68
=IF(AND(A1=1,B1=2),25,IF(AND(A1=1,B1=3),28,IF(AND(A1=5,B1=5),32,"")))