How to create an text based spreadsheet
Closed
Learner2
Posts
2
Registration date
Tuesday May 24, 2016
Status
Member
Last seen
May 24, 2016
-
May 24, 2016 at 05:58 PM
Blocked Profile - May 24, 2016 at 07:34 PM
Blocked Profile - May 24, 2016 at 07:34 PM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Tmobile data check - Guide
- Functions of spreadsheet - Guide
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. learn more ✓ - Facebook Forum
- How to be offline in whatsapp when data is on - Guide
- We limit the number of times you can request security codes in a given amount of time. we have this limit to protect your security. for help accessing your account, learn more, or try again later. - Facebook Forum
2 responses
Please reference the IF syntax below:
=IF(a1="yes,"A1=YES","NOPE, IT DOESN"T WORK!")
The format for the above Statement, is as follows:
=IF(Logic_test,true,false)
You can nest IF statements, as in:
=IF(A1="yes",IF(B1="yes","THEY ARE BOTH YES!","ONLY A1 is yes"),"neither one is yes")
I hope this has helped, and you have learned a little. Post back some code if you get stuck!
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney
=IF(a1="yes,"A1=YES","NOPE, IT DOESN"T WORK!")
The format for the above Statement, is as follows:
=IF(Logic_test,true,false)
You can nest IF statements, as in:
=IF(A1="yes",IF(B1="yes","THEY ARE BOTH YES!","ONLY A1 is yes"),"neither one is yes")
I hope this has helped, and you have learned a little. Post back some code if you get stuck!
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney
Ok, so you may have to make those paragraphs into "RANGES". We cannot programmatically format the sheets for you!
Logic test against the RANGES!
See Below.
NOTICE the window that has "select" in it! That is a RANGE of the cells that have a value in them. Does this make sense?
Now you can test against RANGES!
It's kind of fun to do the impossible! -Walter Elias Disney
Logic test against the RANGES!
See Below.
NOTICE the window that has "select" in it! That is a RANGE of the cells that have a value in them. Does this make sense?
Now you can test against RANGES!
It's kind of fun to do the impossible! -Walter Elias Disney
May 24, 2016 at 07:09 PM
So my intent would be to put in "1" into cell A1 and for it then to show the text paragraph appearing in another cell.
ac3mark - so grateful for your answer but not working for me at the moment. I expect it is my fault. Kind Regards and thanks for your endeavour. If you can indicate a solution I will be very grateful.