Ask your own question, for FREE!
Computer Science 14 Online
OpenStudy (osanseviero):

I need help for a google drive spreadsheet function. In A1, I will have 0, 10 or 20. That will be the value that any user will put. Then B1 will depend. If A1=0, B1 needs to be 19. If A1=10, B1 needs to be 20. And if A1=20, B1 needs to be 22. How can I make B1 to change depending of the input in A1?

OpenStudy (lyrae):

Paste this into B1: =IF(A1=0;19;IF(A1=10;20;IF(A1=20;22;"Value not 0,10,20")))

OpenStudy (osanseviero):

Perfect!

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Latest Questions
Arriyanalol: i need help
1 day ago 7 Replies 1 Medal
Arriyanalol: CONGRATS to me
1 day ago 8 Replies 2 Medals
Legomaster346: What colleges are good that are near Arab Alabama?
1 week ago 5 Replies 0 Medals
Arriyanalol: i need help
1 week ago 6 Replies 2 Medals
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!