Results 1 to 9 of 9

Formula needed to save manual input

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Formula needed to save manual input

    Hello.
    In any given set of fixtures, I want to enter each home team in column X and each away the team in column Y.
    Is there a way to have the Home Strength calculation show in columns Z and the Away Strength calculation show in columns AA without having to do it manually?

    Each home team's strength number is determined by multiplying the home attacking strength (HAS) in column T with the away defensive strength (ADS) in column W with Cell H30 (T*W*H30)
    Each away team's strength is worked out by multiplying the away attacking strength (AAS) in column V with the home defensive strength (HDS) in column U with Cell Q30 (V*U*Q30)

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell that allows both formula and manual input options
    By Rustico18 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2017, 01:53 AM
  2. Replies: 7
    Last Post: 07-02-2016, 07:26 PM
  3. Option to put in manual input without erasing the formula.
    By shamsul in forum Access Tables & Databases
    Replies: 3
    Last Post: 07-02-2016, 12:35 AM
  4. [SOLVED] Cell equals formula OR manual input
    By PDBartlett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2014, 05:52 AM
  5. Replies: 1
    Last Post: 02-24-2013, 06:27 PM
  6. [SOLVED] Formula and Manual Input
    By Yidolee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-18-2013, 01:37 PM
  7. Changing code from Manual input to Calculated input
    By Gertheking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2012, 11:41 AM

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