Is this kind of calculation possible on Infopath form?

[Fred Boer]

Hi all:

I just tried Infopath today, and was excited by what I was able to do in a
short time. I am working on a travel cost reimbursement form, and I have a
question

Can Infopath manage this kind of calculation:

"If mileage costs claim is for less than 200 kilometers, calculate cost at
25 cents per kilometer, but if it is over 200 kilometers calculate cost at
32 cents a kilometer..."

Thanks!

 

[Paresh]

Hi all:

I just tried Infopath today, and was excited by what I was able to do in a
short time. I am working on a travel cost reimbursement form, and I have a
question

Can Infopath manage this kind of calculation:

"If mileage costs claim is for less than 200 kilometers, calculate cost at
25 cents per kilometer, but if it is over 200 kilometers calculate cost at
32 cents a kilometer..."

Thanks!

Yes, calculations are surely possible in InfoPath forms. One of the
informative links is as follows:
http://office.microsoft.com/en-us/infopath/HP100343591033.aspx

Thanks,
Paresh
http://pareshs.wordpress.com/

 

[S.Y.M. Wong-A-Ton]

You can add Conditions on Rules for the "if-statements" in your calculations.
Also see
http://www.bizsupportonline.net/infopath2007/infopath-basics-understanding-rules-infopath.htm

 

[Fred Boer]

Thanks a lot! It was much easier than I thought. But I'll be posting new
questions soon. I think I might like this program!

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

Hi all:

I just tried Infopath today, and was excited by what I was able to do in a
short time. I am working on a travel cost reimbursement form, and I have a
question

Can Infopath manage this kind of calculation:

"If mileage costs claim is for less than 200 kilometers, calculate cost at
25 cents per kilometer, but if it is over 200 kilometers calculate cost at
32 cents a kilometer..."

Thanks!

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available
here:http://www3.sympatico.ca/lornarourke/

Yes, calculations are surely possible in InfoPath forms. One of the
informative links is as follows:
http://office.microsoft.com/en-us/infopath/HP100343591033.aspx

Thanks,
Paresh
http://pareshs.wordpress.com/

 

[Fred Boer]

Thank you for your help! It is most appreciated!