Div problem

[#1]

Hi!

Let's say i have a excel file with two parameters value1 and value2. Lets say that value1= 50 and value2 = 100.

Now i want to present the division of these numbers (50/100 = 0.5) in a Gauge chart, should i not take Div(value1,value2) ?

I cant get this to work, thanksfull for answers!

[#2]

EDIT: I guess my problem is that 0.6 is rounded down to 0. How can i fix that, because if I take 100/100 the Guage chart shows 1, so the functions is working fine.

[m_woolf · Accepted solution]

Try:

=value1/value2

[#4]

Sweet, that did work! Thx.