Set cell value [Solved/Closed]

Jaspinder - Mar 28, 2015 at 10:27 PM - Latest reply: MaxStart 346 Posts Tuesday March 3, 2015Registration dateContributorStatus July 3, 2015 Last seen
- Mar 28, 2015 at 11:35 PM
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....

See more 

1 reply

MaxStart 346 Posts Tuesday March 3, 2015Registration dateContributorStatus July 3, 2015 Last seen - Mar 28, 2015 at 11:35 PM
0
Thank you
=IF(AND(A1=1,B1=2),25,IF(AND(A1=1,B1=3),28,IF(AND(A1=5,B1=5),32,"")))