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....

Set cell value
Time set day - Guide
If cell contains date then return value ✓ - Excel Forum
Winrar set password not working - Guide
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

1 response

Answer 1 / 1

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,"")))

Similar discussions

Excel - IF function with multiple words

help me to add particular cells

If cell = date return yes or no.

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!