A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I'm new to this...



 
 
Thread Tools Display Modes
  #1  
Old December 20th, 2005, 09:29 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default I'm new to this...

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?
  #2  
Old December 21st, 2005, 02:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default I'm new to this...

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?



  #3  
Old December 21st, 2005, 11:39 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default I'm new to this...


Allsmiles3237 Wrote:
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


--
zahoulik
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:56 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.