Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel formula qeustion

  • 05-12-2009 4:49pm
    #1
    lpm
    Registered Users, Registered Users 2 Posts: 49 ✭


    Hi
    What formula would I need to use if I want to get excel to automatically
    fill in the % of something
    Example:
    IF I put €100 in colum A and need excel to put €21.50 into column B

    Thanks


Comments

  • #2
    5uspect
    Moderators, Arts Moderators Posts: 10,520 Mod ✭✭✭✭5uspect


    Click on B1 (or where ever) and enter 
    =A1*0.215

    Drag or double click the fill handle down to auto fill the rest of the column.


  • #3
    lpm
    Registered Users, Registered Users 2 Posts: 49 ✭lpm


    ;);)Cheers


Advertisement