ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiplication problem (https://www.excelbanter.com/excel-programming/339171-multiplication-problem.html)

Ali Baba

Multiplication problem
 
Hello

Click on the link below to view the problem
http://phpaw.com/myscrpit/milt-up/jp...1125872703.jpg

I am not sure whether to use select case function or if-then

Thanks for any help

Earl Kiosterud

Multiplication problem
 
Ali,

Unless I've totally missed the point, perhaps you can write:

Select Case UserChoice
Case is = 1
Result = (3*x^2)*(4*x^3)
Case is = 2
Result = (1 - x^4) * 6 * x
End Select

Or

If UserChoice = 1 then
Result = (3*x^2)*(4*x^3)
Elseif UserChoice = 2 then
Result = (1 - x^4) * 6 * x
End if
--
Earl Kiosterud
www.smokeylake.com

"Ali Baba" wrote in message
...
Hello

Click on the link below to view the problem
http://phpaw.com/myscrpit/milt-up/jp...1125872703.jpg

I am not sure whether to use select case function or if-then

Thanks for any help





All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com