Work related project Excel 2010 [closed]
I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain word occupies the cell from the list in that cell that in a different cell the value will be zero. The second function in the formula is that in that very same cell if the condition isn't met then the number that shows in A1 will be the multiplication of the number in A2 by 20. In short, this is my equation and it comes out with a #Name? error
=IFS(G3="その他",I4*0,G3=私有車公務使用,I4*20)
The language is Japanese and I am using a Japanese computer. I am sure there is a problem with my equation but i6 am not sure where to start. Could I get some help? Is it even possible to do something like this?
I have Excel 2010.
microsoft-excel worksheet-function
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
asked Dec 12 at 2:37
Isaac
1
closed as unclear what you're asking by fixer1234, VL-80, Rajesh S, Pimp Juice IT, music2myear Dec 17 at 18:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain word occupies the cell from the list in that cell that in a different cell the value will be zero. The second function in the formula is that in that very same cell if the condition isn't met then the number that shows in A1 will be the multiplication of the number in A2 by 20. In short, this is my equation and it comes out with a #Name? error
=IFS(G3="その他",I4*0,G3=私有車公務使用,I4*20)
The language is Japanese and I am using a Japanese computer. I am sure there is a problem with my equation but i6 am not sure where to start. Could I get some help? Is it even possible to do something like this?
I have Excel 2010.
microsoft-excel worksheet-function
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
asked Dec 12 at 2:37
Isaac
1
closed as unclear what you're asking by fixer1234, VL-80, Rajesh S, Pimp Juice IT, music2myear Dec 17 at 18:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
3
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
try correctingG3=私有車公務使用toG3="私有車公務使用"
– p._phidot_
Dec 12 at 3:29
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33
add a comment |
I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain word occupies the cell from the list in that cell that in a different cell the value will be zero. The second function in the formula is that in that very same cell if the condition isn't met then the number that shows in A1 will be the multiplication of the number in A2 by 20. In short, this is my equation and it comes out with a #Name? error
=IFS(G3="その他",I4*0,G3=私有車公務使用,I4*20)
The language is Japanese and I am using a Japanese computer. I am sure there is a problem with my equation but i6 am not sure where to start. Could I get some help? Is it even possible to do something like this?
I have Excel 2010.
microsoft-excel worksheet-function
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
asked Dec 12 at 2:37
Isaac
1
I am by far not an expert and am only beginning to see the complexity that is Excel. I am trying to write a formula (if it is even possible) that will allow me to make a condition that if a certain word occupies the cell from the list in that cell that in a different cell the value will be zero. The second function in the formula is that in that very same cell if the condition isn't met then the number that shows in A1 will be the multiplication of the number in A2 by 20. In short, this is my equation and it comes out with a #Name? error
=IFS(G3="その他",I4*0,G3=私有車公務使用,I4*20)
The language is Japanese and I am using a Japanese computer. I am sure there is a problem with my equation but i6 am not sure where to start. Could I get some help? Is it even possible to do something like this?
I have Excel 2010.
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
asked Dec 12 at 2:37
Isaac
1
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
asked Dec 12 at 2:37
Isaac
1
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
edited Dec 12 at 2:48
Twisty Impersonator
17.7k136395
17.7k136395
asked Dec 12 at 2:37
Isaac
1
asked Dec 12 at 2:37
Isaac
1
asked Dec 12 at 2:37
Isaac
1
1
closed as unclear what you're asking by fixer1234, VL-80, Rajesh S, Pimp Juice IT, music2myear Dec 17 at 18:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by fixer1234, VL-80, Rajesh S, Pimp Juice IT, music2myear Dec 17 at 18:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
3
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
try correctingG3=私有車公務使用toG3="私有車公務使用"
– p._phidot_
Dec 12 at 3:29
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33
add a comment |
3
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
try correctingG3=私有車公務使用toG3="私有車公務使用"
– p._phidot_
Dec 12 at 3:29
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33
3
3
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
try correcting
G3=私有車公務使用 to G3="私有車公務使用"– p._phidot_
Dec 12 at 3:29
try correcting
G3=私有車公務使用 to G3="私有車公務使用"– p._phidot_
Dec 12 at 3:29
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
3
The description is a bit ambiguous. One apparent problem is that the second G3= doesn't have quotes around what I assume is a text string.
– fixer1234
Dec 12 at 2:53
try correcting
G3=私有車公務使用toG3="私有車公務使用"– p._phidot_
Dec 12 at 3:29
For better understanding replace text with English text and put some Screen Shot also!! If G3=Cell Range then you need an Array Formula so better make it clear G3=What Text or Data Range !!
– Rajesh S
Dec 12 at 7:09
Can you please edit your question to give us sample data and the exp[ected outcome?
– cybernetic.nomad
Dec 12 at 12:33