@Carl Love 

Okok,

but I think there is a further error in my spreadsheet, becouse if I "execute" calculation:

GlobalOptima(Fm(x),[x=0..Xa],Maximize)

Error, (in psi2) invalid input: KelvinBer expects its 2nd argument, x, to be of type algebraic, but received 0 .. Xa.

Furthermore, completed this calculation, I would like to know if maple can automatically take  v, Q3, Xa to excel cells and give me back into other cell max (Fm (x) ....

Thank you for your patience, but I'm considering the purchase of a license for my company and I have to be sure that execute these calculations.

@Carl Love 

ok, I installed DirectSearch but I have an error  in file attached

Download UHX13.1-13.2.mw

The same min and max I need for Ft. There is a way to export maple code in excel?

@Carl Love 

I try to explain. I need the max and min values of a function, es: f(x)=x^0.5  0<x<3

min f(0)=0

max F(3)=1.732

It is simply the max and min global or local of a continuous function.

In this case the function's name is Fm(x) and I would like to know:

-in maple software: the wording to have global and local point of min and max;

-in excel: the same as above but in excel using maple add-in

Regarding abs... I have f(x), min f(x)= -5 ----->     abs(min(f(x))= abs(-5)=5

I only want to calculate min and max of function and in case these are negative, replacing with +

@Carl Love 

@Markiyan Hirnyk 6939

Thank you all,

I have one last question:

-I define 2 function Qm and Qv, I use these in another function, but results show parameter in results, I need numeric values!!! How can I do?

=maple("Fm:=x->(Qv+&1*Qm)/2";B3)

=maple("G:=map(g->evalf(eval(Fm(x),x=g)),[A])")------->

results: G:=[0.5*Qv+.3665e-1*Qm,....] I need a number!!

In attached excel file, the new formula with numeric values I need is Fm(x)UHX-13_02.xlsx

Bye!