Excel Case/else structure math operations.

[bigdog332]

having issues doing this im in a class for this and not able to make this work will it will ask me what math operation i would like to do anybody that can help?

[bigdog332]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[cytop]

Too many issues...

• You call a function that doesn't exist.
• The function to actually do the calculation is not called.
• You have no way to input the required operation.
• Syntax errors.
• Other than a syntax error, your Case statement is correct
• Declaring variables as integers could easily cause an overflow error.
• Your post does not comply with the board rules regarding code tags.

Perhaps a read of this would be more educational than someone just doing it for you

[bigdog332]

well i got everything else to work up to the point of the program asking for what math operation to commit. So i had it programmed where i just entered the numbers and it added them but im just lost where i can get it to ask for which math operation to work

[bigdog332]

this is what i have working now and it does addition right away im just trying to make it ask for the math operation and can't find anything to led me towards it asking that one question.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[arlu1201]

bigdog,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

[MrShorty]

Don't you simply need a third input box statement that asks the user for the operation type?