Help with text & number rule!
Solved/Closed
Alulus
Posts
5
Registration date
Friday January 3, 2014
Status
Member
Last seen
January 3, 2014
-
Jan 3, 2014 at 01:58 PM
Alulus Posts 5 Registration date Friday January 3, 2014 Status Member Last seen January 3, 2014 - Jan 3, 2014 at 03:42 PM
Alulus Posts 5 Registration date Friday January 3, 2014 Status Member Last seen January 3, 2014 - Jan 3, 2014 at 03:42 PM
Related:
- What is the general rule for configuring the initial size of a paging file?
- Windows 10 iso file download 64-bit - Download - Windows
- Safari cannot open the page because it is a local file - Guide
- Gta 5 size for windows 11 download free - Download - Action and adventure
- Mtu size calculator - Guide
- Kmspico zip file download - Download - Other
5 responses
Al,
The logic for if then is:
=if(logic_test,true, false)
So, with that in mind:
cell B1=if(A1="SOMETEXT",Numerical_value_specified)
Yes, it is simple.
Post back if not what you want, as this satisfies your questions scope/requirement.
//ark
-Moderator/Contributor
The logic for if then is:
=if(logic_test,true, false)
So, with that in mind:
cell B1=if(A1="SOMETEXT",Numerical_value_specified)
Yes, it is simple.
Post back if not what you want, as this satisfies your questions scope/requirement.
//ark
-Moderator/Contributor
Yes, Al. You can NEST if then statements like so:
=if(logic_test1,true_logic_test1,if(logictest2,true_logic_test2,false_logic_test2))
This would test logic 1, and only upon false, check logic test 2.
I have done this before (although frowned upon by others):
=IF(A1=1,"ONE",IF(A1=2,"TWO",IF(A1=3,"THREE",IF(A1=4,"FOUR"))))
Have Fun!
//ark
-Moderator/Contributor
=if(logic_test1,true_logic_test1,if(logictest2,true_logic_test2,false_logic_test2))
This would test logic 1, and only upon false, check logic test 2.
I have done this before (although frowned upon by others):
=IF(A1=1,"ONE",IF(A1=2,"TWO",IF(A1=3,"THREE",IF(A1=4,"FOUR"))))
Have Fun!
//ark
-Moderator/Contributor
Alulus
Posts
5
Registration date
Friday January 3, 2014
Status
Member
Last seen
January 3, 2014
Jan 3, 2014 at 02:58 PM
Jan 3, 2014 at 02:58 PM
GREAT!!
After some minor tweaking (reversing your quotation marks)... I got it to work! Amazing. My "Excel Friend" will be more than impressed!
Just one last request to make everything perfect.... How do I indicate in the formula that if I enter "nothing" in Cell A, I get "nothing" in Cell B?
The way it is now.. I get a FALSE word popping into B.
After some minor tweaking (reversing your quotation marks)... I got it to work! Amazing. My "Excel Friend" will be more than impressed!
Just one last request to make everything perfect.... How do I indicate in the formula that if I enter "nothing" in Cell A, I get "nothing" in Cell B?
The way it is now.. I get a FALSE word popping into B.
Alulus
Posts
5
Registration date
Friday January 3, 2014
Status
Member
Last seen
January 3, 2014
Jan 3, 2014 at 03:05 PM
Jan 3, 2014 at 03:05 PM
Ohhh..... I seemed to have solved the problem.. not sure how...
Now when I type nothing into cell A, I get a 0 in cell B.. which is suitable!
Now when I type nothing into cell A, I get a 0 in cell B.. which is suitable!
Al, I am happy it is working, I hope I am not doing homework! :)
Take a look at the below statement, and notice the last FALSE statement:
=IF(A1=1,"ONE",IF(A1=2,"TWO",IF(A1=3,"THREE",IF(A1=4,"FOUR",""))))
That says, all false, nothing!
Mark it up as solved if you are happy.
Take a look at the below statement, and notice the last FALSE statement:
=IF(A1=1,"ONE",IF(A1=2,"TWO",IF(A1=3,"THREE",IF(A1=4,"FOUR",""))))
That says, all false, nothing!
Mark it up as solved if you are happy.
Didn't find the answer you are looking for?
Ask a question
Alulus
Posts
5
Registration date
Friday January 3, 2014
Status
Member
Last seen
January 3, 2014
Jan 3, 2014 at 03:42 PM
Jan 3, 2014 at 03:42 PM
Yes everything's working perfectly!
I have nothing typed into the formula concerning a blank space, but when I type nothing into Cell A, I get nothing in Cell B. I don't even get the word FALSE now.
One thing I changed though, was the formatting of Cell B. Changed to Accounting. So now I just get a $ sign, with a -, indicating there's no value present in Cell B. Which is exactly what I wanted.
Sure appreciate the HOURS of time you've just saved me. Thank you!! (I know very little about Excel).
NOW....
Pick a question... any question... perhaps I can be of help in return. :-)
I have nothing typed into the formula concerning a blank space, but when I type nothing into Cell A, I get nothing in Cell B. I don't even get the word FALSE now.
One thing I changed though, was the formatting of Cell B. Changed to Accounting. So now I just get a $ sign, with a -, indicating there's no value present in Cell B. Which is exactly what I wanted.
Sure appreciate the HOURS of time you've just saved me. Thank you!! (I know very little about Excel).
NOW....
Pick a question... any question... perhaps I can be of help in return. :-)
Jan 3, 2014 at 02:18 PM
Is it just as easy to add more to that formula?
For instance - I have 3 interchangeable words I typically want to use in cell A, with a different numerical value I would like to programme to show in cell B for the particular word that I type.
Also, if there's no word entered in A (or a completely different word that I haven't specified in the formula) - then I would want to enter in my own numerical value in B for that word.