Set cell value
Solved/Closed
Jaspinder
-
Mar 28, 2015 at 10:27 PM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Mar 28, 2015 at 11:35 PM
MaxStart Posts 338 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....
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....
Related:
- Set cell value
- How to set auto redial on android - Guide
- How to set viber offline - Guide
- Winrar set password not working - Guide
- How to set whatsapp time - Guide
- How to set nitro as default - Guide
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 28, 2015 at 11:35 PM
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,"")))