I've been asked to create an interactive form in Excel that does caculations.
The form has already been created in AdobeDesign but because the client i'm
working for doesn't support Adobe 7.0, the form can not be used. It's an
recorts disposal form that need to be able to do caculations. I'm good with
the caculations, but can't seem to figure out how to create to form itself.
Can someone please point me in the right direction?

Treat the worksheet as the "Form", using cells with formulas for the calculation, lots of labelling
and formatting of cells to clearly indicate where the inputs should be entered.....

HTH,
Bernie
MS Excel MVP


"Allsmiles3237" wrote in message
...
I've been asked to create an interactive form in Excel that does caculations.
The form has already been created in AdobeDesign but because the client i'm
working for doesn't support Adobe 7.0, the form can not be used. It's an
recorts disposal form that need to be able to do caculations. I'm good with
the caculations, but can't seem to figure out how to create to form itself.
Can someone please point me in the right direction?

Something else you might want to look at... if you click on the "paste function" button at the top (looks like a little fx), you can explore all of the functions that Excel offers. It looks really complicated, but if you have an idea of what you're looking for... for example, SUM, AVERAGE, and PRODUCT are basic and easy to use. Just play around with it for a while and you'll get the hang of it.

Z