+ Reply to Thread
Results 1 to 6 of 6

Excel Formula equivalent of Access Formula

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel Formula equivalent of Access Formula

    hi guys,

    i hope that you can help me on this, basically what i need is a formula that can do a calculation if, e.g.

    A=true then B will be updated , however if A=false then B will stay blank.

    also just a long shot but does anyone know if when i create a database in access would i be able to upload or import a formula from excel that would run in a form in access and make a calculation for me when i input new data, This would be a lot easier for me as i have also set up a database in access 2007 but got stuck on trying to enter calculations,

    I know that this is a excel forum but if anyone by any chance would be able to shed a bit of light on this situation it would be much appreciated.

    thanks in advance Adam.
    Last edited by Richard Buttrey; 01-13-2010 at 07:23 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,545

    Re: formulas in excel

    Hi

    In B1

    =IF(A1=True,"yourvalue","")

    I believe the formulae syntax in Access is different to Excel hence I don't believe you can simply use an excel formula.

    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-13-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: formulas in excel

    thankyou, would i also be able to enter a fourula for example

    =IF(A1=True,"C1/100*2","")

    would this work or do i have do do it another way .. i will ttach the file i have below then you may get a better understanding of what i mean .. once again thankyou.
    Attached Files Attached Files

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: formulas in excel

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,545

    Excel Formula equivalent of Access Formula

    Hi,

    I've changed your title for you following Roy's comment, but please remember for any new threads.

    The example you ask about won't work if you're expecting to calculate a value based on the C1 value. You need to remove the quotes around "C1/100*2".

    I used the IF(A1=True... since this was the way you described it on your original post. However you may mean to be testing whether A1 contains a value or a specific value. If so instead use.

    =IF(A1<>"",......
    or
    =IF(A1=yourvalue,.....

    HTH

  6. #6
    Registered User
    Join Date
    01-13-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel Formula equivalent of Access Formula

    thankyou once again .. im useless with these things lol ..

    and thanks for that i will try it now and see how i goes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1