Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-02-2009
Member
 
Join Date: May 2008
Posts: 962
How to perform calculations with conditions in Excel ?

I would like to create a form in Excel (that I know do), but I would like to create the conditions of addition and calculations once completed the form.

How do I create these forms and their conditions? Visual Basic? If yes, do you know a good site for beginner clearly explaining how to perform calculations with conditions and view the responses to these conditions?

I hope I am clear ...

Ex:
Garage: 1
Salon: 2
Room: 5
Is there a garden: yes
Is there a swimming pool: no
...
Total elements:?


I would for example add the total of parts and yes! But also limit, for example, the number of pieces on the floor to 4 (even if it says 5) and even better, a message in a cell defined if exceeded 4 parts ". ..

There are an infinite number of things to achieve that effect, but otherwise performs there this kind of thing in Excel?
Reply With Quote
  #2  
Old 06-02-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: How to perform calculations with conditions in Excel ?

Want an Excel roughly as I have before ...

We realize this kind of thing, with conditions 'if' essentially ... Now it is possible to make things very complicated.

A key issue remains to clearly and define clearly what you want to do, so that the transcript formula becomes obvious.

Site to start somewhere, and even to go much further:

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
Writing Your First VBA Function in Excel
Reply With Quote
  #3  
Old 06-02-2009
Member
 
Join Date: May 2008
Posts: 962
Re: How to perform calculations with conditions in Excel ?

Thank you XSI.

So if I understand all these complex calculations have to be written with VBA. And I can trigger these actions by clicking on a button. That's right? But VBA is that I do not know yet. I do not understand how to run these activities. Do they engage with macros, automatically?
Reply With Quote
  #4  
Old 06-02-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: How to perform calculations with conditions in Excel ?

No ... lots of complex calculations can be written with functions ... but hey, that tell you more than using Excel ... ?

if function works: if (condition, value if yes, value if false), so nothing very hard to understand ... Now there are many other functions that you will ... you must be curious and look into the functions of Excel ... I did not really have any other advice.

Otherwise, yes, the VBA can be triggered by a button that actually launches the macro.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to perform calculations with conditions in Excel ?"
Thread Thread Starter Forum Replies Last Post
Need help to perform scheffe test in Excel AdilShaikh18 MS Office Support 4 03-01-2014 10:20 AM
Tips for making calculations in Microsoft Excel. Jaques Strapp Tips & Tweaks 0 08-01-2012 11:09 AM
To speed up calculations on a Worksheet Bankebihari Windows Software 3 10-04-2009 12:07 PM
How to use Textbox values for calculations Sonic Software Development 4 26-11-2008 08:17 PM
Excel function calculations used in MS Access query akbar MS Office Support 1 23-05-2008 08:52 PM


All times are GMT +5.5. The time now is 04:49 AM.