Results 1 to 3 of 3

Advice on creating a formula for two different conditions

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2012
    Location
    London, United Kingdom
    MS-Off Ver
    Excel365 Version 2210
    Posts
    46

    Advice on creating a formula for two different conditions

    Dear All,

    I was wondering whether anyone here could point me how to and whether it is even possible to create a formula for my issue?

    I am working on the spreadsheet which cannot contain any macros, only formulas which makes everything a bit more difficult. The issue which I have come across is to write a formula for coordinates of four points meeting coordinates of other four points.I know, I sound confusing so please allow me to explain it below:

    If coordinates of top piles Lx (cell no. T9) & Ly (cell no. U9) are met with coordinates in cells no. F9:G38 and if coordinates of bottom piles Lx (cell no.T14) & Ly (cell No.U14) are met with coordinates in cells no. F9:G38 then number of piles in cell no. U16 is cell no. E4+2.

    Could anyone advice how this could be achieved?

    I hope above makes sense, if not please let me know.

    Thank you in advance for your help on this.

    Kind regards,

    Jan
    Attached Files Attached Files
    Last edited by jankrulak; 04-28-2020 at 06:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] New rule creation advice needed / 2 conditions need to be met
    By kavruka in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2016, 01:45 PM
  2. Advice of highlighting under conditions.
    By Bryony309 in forum Excel General
    Replies: 3
    Last Post: 11-25-2015, 04:50 PM
  3. Creating formula to populate on certain conditions
    By XrisHess in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2015, 09:54 AM
  4. Need Advice with creating formula
    By Edgars.Aronietis in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-22-2014, 04:33 AM
  5. [SOLVED] Creating Max If Formula with multiple conditions
    By Zanenep in forum Excel General
    Replies: 4
    Last Post: 05-07-2012, 11:46 AM
  6. Need advice creating a formula to solve a problem
    By shadestreet in forum Excel General
    Replies: 1
    Last Post: 09-21-2006, 11:50 AM
  7. [SOLVED] Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!!
    By So Tru Geo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 02:15 PM

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