Calculating the decimal part value of a Percentage

[Shilpa16]

Hello Everyone,

I have a scenario where I need to lookup the percentages to absolute numbers as shown below:

%        Value

1%     200

2%    270

3%    340

Suppose I get % as 2.7 then I need to do the following calculation:

340-270=70

70/10=7

7*0.7=4.9

270+4.9=274.9

Could anyone please suggest how can I do such a calculation? Is there any direct function to be used?

Thanks

Shilpa

[olivetwist]

I was able to make it work using an input box for the % as variable "vIN" then used the formula below in a text object.

app attached.

=SUM(IF(FLOOR(vIN)=LEFT(%,1),VALUE))+((SUM(IF(CEIL(vIN)=LEFT(%,1),VALUE))-SUM(IF(FLOOR(vIN)=LEFT(%,1),VALUE)))/10)*FMOD(vIN,FLOOR(vIN))