Ask
your own question, for FREE!
Computer Science
6 Online
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?
Still Need Help?
Join the QuestionCove community and study together with friends!
Paste this into B1: =IF(A1=0;19;IF(A1=10;20;IF(A1=20;22;"Value not 0,10,20")))
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!
Join our real-time social learning platform and learn together with your friends!
Latest Questions
thereneelg:
Okay....I'm doing a group solo for choir. Auditions are Tuesday (?), Any tips on
Arizona:
my Rolling stone airpods won't connect and I got them about a year ago is there t
Arizona:
can someone check out my essay i'm doing in my senior English class about the McD
IcedShots:
I was wondering, is there anybody on here around my age? Im turning 15 on December 1 ud83dude0a.
thatonenerd:
Use Hvap of water = 40.7 kJ/mol, c of water = 4.184 J/g.u00b0C, and molar mass of HO = 18.
letrasbonitasz:
Typography plays an important role in digital communication. Different font styles can make social media profiles, usernames, messages, and creative designs
Bounty:
tested love: im so over love it acquires patience i don't have trials an tribulations yet my souls the only one taken i give 90 you give 10 you say that you
SaltySuga:
is it possible to tell how deep a cut is by an open wound? like would i be able t
AndreW2002:
I'm trying to change my profile picture but it keeps saying "Either a error occurred, or you tried to upload a gif" but it's not a gif that I'm using, it's
9 hours ago
0 Replies
0 Medals
16 hours ago
3 Replies
0 Medals
1 day ago
1 Reply
0 Medals
16 hours ago
3 Replies
0 Medals
2 days ago
5 Replies
0 Medals
4 days ago
3 Replies
1 Medal
2 days ago
7 Replies
2 Medals
5 days ago
5 Replies
1 Medal
6 days ago
3 Replies
0 Medals