Set cell value

Solved/Closed
Jaspinder - Mar 28, 2015 at 10:27 PM
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - 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....

1 response

MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Mar 28, 2015 at 11:35 PM
=IF(AND(A1=1,B1=2),25,IF(AND(A1=1,B1=3),28,IF(AND(A1=5,B1=5),32,"")))

0