Results 1 to 9 of 9

Creating conditional calculations

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2009
    Location
    Bromsgrove, England
    MS-Off Ver
    Excel 2003
    Posts
    53

    Creating conditional calculations

    I have a project (spreadsheet attached). Im going to be adding lots of data with a similar theme.

    In cell X there will be a number for the width and in cell Y a number for the length. On the sample sheet cell X is 508 and Y is 1.

    You will then see in cells F, H, I, S, AF, AG and BK it references the number 508 and 1. I want to create a formula or function whereby I can automatically input whatevers in cell X and Y.

    My initial thought is to replace 508 in F, H, I, S, AF, AG and BK with PRODUCTWIDTH and 1 in 508 in F, H, I, S, AF, AG and BK with PRODUCTLENGTH. Then make a formula that will automaticlaly change the word PRODUCTWIDTH to whats in cell X and PRODUCTLENGTH to whats in cell Y.

    Whats the best way to do this?
    Attached Files Attached Files

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